Changing figures bottom axis text from numbers to time

[libertyforall]

I have successfully worked out what I need to filter date
using pivot tables. Now I am creating graphs using the data. I have
figured out most things but I am still unable to rename the bottom
axis data from simple numbers to various things. At the moment, I want
to change it to times from 12 am to 11:30pm instead of 1 to 47. My
plot shows the time on the bottom axis and the temperature on the
vertical axis. How can I change the text? Is there a way to manually
change the text once the graph is plotted or is there a specific way
to change the text?

 

[AltaEgo]

You could use mathematics to turn your times into integers and plot with
these data rather than time values.

=INT(A3*48)

 

[dheaton]

           I have successfully worked out what I need to filter date
using pivot tables. Now I am creating graphs using the data. I have
figured out most things but I am still unable to rename the bottom
axis data from simple numbers to various things. At the moment, I want
to change it to times from 12 am to 11:30pm instead of 1 to 47. My
plot shows the time on the bottom axis and the temperature on the
vertical axis. How can I change the text? Is there a way to manually
change the text once the graph is plotted or is there a specific way
to change the text?

Are you using a pivot chart?

If so you'll need to change the headings in the pivot table.

Regards

David