Changing the Y axis on a column chart
 

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.

Changing the Y axis on a column chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Haigy" wrote in message
...
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.