|
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....
|