[Last month label is not displying in lines graph]

Hi,

I have a series of data from January-08 to December-08,

The graph is showing fine but In the X Axis it showing labels from January to November only, December is missing

 and in Bar graph label December also showing fine only problem with Lines graph

 

HTML code:

    <ChartFX:Chart id="Chart_CumulativeReturn" runat="server" LineWidth="2" Gallery="Lines" MarkerShape="None"           BackColor="ControlLight" BorderColor="#A8A8A8" Width="1000px" Height="450px"  NValues="0"  >           <ConstantLines><ChartFX:ConstantLine Axis=Y Value=1000 Color=black /></ConstantLines>           <AxisY Title-Text="Growth of $1,000"></AxisY>           <LegendBoxObj TextColor="ControlText" Docked="Bottom"></LegendBoxObj>           <SerLegBoxObj Docked="Bottom"></SerLegBoxObj>           <AxisX MinorTickMark="None" Title-Text="Date" Step="31"  >             <LabelsFormat CustomFormat="MMM-yy" Format="Date" ></LabelsFormat>           </AxisX>   <Series>   <chartfx:SeriesAttributes />   <chartfx:SeriesAttributes />   </Series>         </CHARTFX:CHART>

 

VB Code:

  Chart_CumulativeReturn.DataSourceSettings.DataType(0) = SoftwareFX.ChartFX.DataType.Label   Chart_CumulativeReturn.DataSourceSettings.DataType(0) = SoftwareFX.ChartFX.DataType.Value   Chart_CumulativeReturn.DataSourceSettings.DataType(1) = SoftwareFX.ChartFX.DataType.Label   Chart_CumulativeReturn.DataSourceSettings.DataType(1) = SoftwareFX.ChartFX.DataType.Value

          Chart_CumulativeReturn.DataSource = objDataSet

      Chart_CumulativeReturn.DataBind() 

data tabel:

Col1   Col2       Col3 

956.00   938.80   2008-01-01 00:00:00.000985.16   906.13   2008-02-01 00:00:00.000936.49   900.69   2008-03-01 00:00:00.000942.58   943.47   2008-04-01 00:00:00.000936.08   953.57   2008-05-01 00:00:00.000910.62   871.56   2008-06-01 00:00:00.000893.41   862.93   2008-07-01 00:00:00.000876.88   873.46   2008-08-01 00:00:00.000844.61   794.15   2008-09-01 00:00:00.000817.41   659.62   2008-10-01 00:00:00.000811.44   610.21   2008-11-01 00:00:00.000812.17   614.97   2008-12-01 00:00:00.000

 

Thank you,

Rao 

[Month and Year values in X Axis are repeating]

Hi,

I have data table like this :

Value1  Value2  Date

1077 830   2008-10-01 00:00:00.0001084   768   2008-11-01 00:00:00.0001135 774   2008-12-01 00:00:00.000

And I am trying to generate lines graph

 Html code:

  <CHARTFX:CHART id="Chart1" runat="server" Gallery="lines" Height="335px" Width="500px" BorderColor="#A8A8A8"             MarkerShape="None" LineWidth="2" PointLabels="True">             <AxisY Title-Text="Growth of $1,000"></AxisY>             <LegendBoxObj TextColor="ControlText" Docked="Bottom"></LegendBoxObj>             <SerLegBoxObj Docked="Bottom"></SerLegBoxObj>             <AxisX Title-Text="Date" MinorTickMark="None" LabelAngle="90">                   <LabelsFormat CustomFormat="MMM-dd-yy" Format="Date"></LabelsFormat>             </AxisX>         </CHARTFX:CHART>

VB code:

          Dim DV As DataView = objDataSet.Tables(0).DefaultView   DV.Sort = "Date" + " asc"   Chart1.DataSource = DV   Chart1.DataBind()

Here the problem is X Axis labels are showing more then 3 dates, depending on chart width the number of date values in x-axis are getting increased with deferent date intervals. In this graph the dates are showing like : oct-05-o8, oct-12-o8, oct-19-o8, oct-26-o8, nov-02-o8, nov-09-o8, nov-16-o8, nov-23-o8, nov-30-o8 and december got missed 

 I just want to display 3 dates in the x-axis as per the data table (oct-01-o8, nov-01-o8, dec-01-o8)

How can I do this, I tried NValues in the code but problem was still there

 

Thank you,

Rao