Thread: Y-Axis Time Charting

Hi,

I am trying to create a line chart using a time format. I am trying to use a range of 6:00 PM to 4:00 AM on the Y -Axis. The problem I am having is that excel will not let me put the range as 6:00 PM to 4:00 AM because it says that the maximum axis value must be greater than the minimum axis value. I attempted to check the "Values in reverse order" box, but then it's reading time backwards and that's not what I need.

For example, I have data plotted at 7:00 PM and data plotted at 4:00 AM. I need the 4:00 AM data be be above the 7:00 PM data vertically.

I hope I made sense here....

That worked!

Thanks for the help!