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