Problem with graph time on y-axis, date on x-axis

Brujo

New Member
Joined
Dec 18, 2007
Messages
3
I have created a graph in Excel 2003 with three columns of data that are the times that the top 3 peak KW occurs during a day. The y-axis of my graph is supposed to be the time in the format "00:00:00" and the x-axis is the day that these occur. For some reason, the y-axis of this graph is not functioning correctly. The original columns of data are already formatted for the correct time format and I have tried to right-click within the y-axis of the graph to adjust the settings, but to no avail. Perplexingly, the correct values are displayed on each data point when I hover over them in the graph. They just seem to arbitrarily find a position that are not relative to each other and not relative to the y-axis, which shows values of 00:00:00 for all axis lines. For reference, the value ranges are set as defined name ranges using an offset function, but those are working correctly and shouldn't make any difference. Thanks for anyone's help with this.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Brujo

New Member
Joined
Dec 18, 2007
Messages
3
I tried to switch to a bubble chart format but that didn't work either.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,267
Messages
5,443,439
Members
405,236
Latest member
JDru85

This Week's Hot Topics

Top