Changing the Y axis on a column chart

H

Haigy

I have a column chart that records the amount of hours/minutes (y axis)
people have been late for each week (x axis). On the y axis I want to change
it so that the intervals are at 5 minutes intervals, e.g. 5 minutes late, 10
minutes late, 15 minutes late etc.

I've looked at the scale options that Excel has set and I can't work out how
or if I can change the scale to what I want.
 
J

Jon Peltier

The Y axis is a continuously variable axis. You can set the scale with a min
of 0 and a major unit (tick spacing) of 5. If you want points to only occur
at the five minute intervals (instead of where the actual times fall) you
will have to round the data to the nearest five minutes.

- Jon
 
Top