1

So I'm starting to play with the Microsoft Chart control for the first time and I ran into an issue.

I'm returning a database query into a List object and using that list object to fill the X and Y axes of my chart as seen below. (_runData is a "List(of DatabaseTableName)" style Object filled with the results of my query.

Primary_Chart.Series(0).Points.DataBindXY(_runData, "DateTime", _runData, "UPPER_PRESSURE")

My Datetime field is returning as a Serial Number (i.e. 40116.76111) so I want to format the X Axis to display the field more readably. Enter my problem code.

Chart_Obj.ChartAreas(0).AxisX.LabelStyle.Format = "MM"

This code changes my axis to display MM instead of the Serial Number. I have experimented with other Formatting type and the result is that my Axis Labels change to read exactly as whatever I put after the = sign.

What am I missing here? Thanks a ton.

Neberu
  • 211
  • 1
  • 8
  • 19
  • No, Answers? Thats rather frustrating as this is a major hurdle that I can not seem to find a decent reason for. – Neberu Feb 18 '11 at 23:16

1 Answers1

1

You need to set the XValueType on the series to DateTime or Date so that the charts know to display the values as datetimes rather than doubles.

Primary_Chart.Series(0).XValueType = ChartValueType.DateTime

For more details see http://msdn.microsoft.com/en-us/library/system.web.ui.datavisualization.charting.series.xvaluetype.aspx

escouser
  • 1,913
  • 19
  • 15