Cfchart time values for Y Axis

[Guest]

Hello,

I am trying to create a graph in cfchart that plots time values as its y axis.  The values are take from a MySQL database and are stored as DateTime so firstly:

How can I convert this to just a 'time' value, i.e. 00:00:30 so that it can be plotted onto the graph?

And then,

how can I plot this onto the graph itself?  I have tried to use the WebCharts.bat to change the format of the y axis to DateTime, but it doesn't seem to work.

Any ideas?

Thanks!!

[Dan_Bracuk]

Are you sure you mean the y-axis and not the x-axis?