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....
In order to get 4am to plot above 6pm you would need to add a day to the 4am value.
That worked!
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks