Display Negative Time Values on Y-Axis

G

GlennR

I'm plotting timed events against a set schedule (actual lap times vs
predicted times) and am calculating the difference and plotting the
results.

In Excel 2003, I would use the 1904 Date System (Tools, Options,
Calculation tab) to display negative time values and then force the
chart to link to the source data to determine the format. It would
display positive and negative time values on the y-axis

In Excel 2007, changing to 1904 date system will show negative time
values in the spreadsheet AND will plot negative points on a chart,
but WILL NOT DISPLAY NEGATIVE TIME VALUES ON THE Y-AXIS. Using fixed
or auto scaling has no effect.

Does anyone have a solution for this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphing Negative Time 1
Positioning x axis at bottom of chart with negative values 5
Use text descriptors as Y axis units 1
Data labels along below x axis when y axis has negative values 1
Negative values on Y axis 1
Make Y-axis values correspond to x- axis value 1
Stack bar charts with positive and negative numbers 2
Negative values on X axis 6

Top