Changing datetime format on mschart axis

Question

I'm using mschart to display some values over a timeperiod.

It looks something like this:

As you can see the first value is from 15:11 and the last from 16:10 But on the x-axis it's on displaying the days. How can I change this?

EDIT: Changing XValueType to ChartValueType.Time leads to this:

Does setting the X axis value type to `ChartValueType.Time` make any difference ? — V4Vendetta, Jan 12 '12 at 10:43
check for the series `Series[0].XValueType = ChartValueType.Time` — V4Vendetta, Jan 12 '12 at 10:47
Good idea, but this leads to another problem... Now it's only using hour and minute... — Kingpin, Jan 12 '12 at 10:57
try setting the `ChartAreas[0].AxisX.LabelStyle.Format` to `HH:mm:ss` or other as you need — V4Vendetta, Jan 12 '12 at 11:06
Yes that's working! Thanks alot.... Make an answer and you get the points :) — Kingpin, Jan 12 '12 at 11:14

score 19 · Accepted Answer · edited Sep 21 '16 at 18:23

19

To show DateTime related values on the XAxis you can choose to set the XValueType property.

In your case Series[0].XValueType = ChartValueType.Time would be the right thing to display time related values.

To format the values you can use ChartAreas[0].AxisX.LabelStyle.Format which would translate your values into the required format say like HH:mm:ss.

ChartAreas[0].AxisX.LabelStyle.Format ="HH:mm:ss";

edited Sep 21 '16 at 18:23

djv

15,168
7
48
72

answered Jan 12 '12 at 11:41

V4Vendetta

37,194
9
78
82

1

How to display AM/PM values ? – VJOY Mar 28 '12 at 11:38
1

A little tip! Use Keywords such as #VALY{HH:mm:ss} if seconds are not displaying. – 27k1 Oct 15 '13 at 14:15
I found that I had to put chartArea1.AxisX.LabelStyle.Format ="HH:mm:ss"; in my designer file before this would work. – Adam Garner Feb 02 '18 at 15:55

Changing datetime format on mschart axis

1 Answers1

Linked