I have a column of time in the h:mm:ss format. If I click on one of these cells, the workling window displays the time plus a "PM" or "AM"
e.g.
cell: 13:12:30
working window: 1:12:30 PM
All good so far....
When I plot time on Xaxis and respective data on the Yaxis I get 0-X numbers (1,2,3 etc...) onthe Xaxis.
I am trying to get the time on the x-Axis, e.g. 13:12:30...
I have tried formating the X-axis to h:mm:ss, the only choice was h:mm:ss; @
I've tried the time formats without any luck also...
Thanks,
Dave
Hi Dave,
can you post a sample file with some of your data and the chart you made?
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks