Changing the Y axis on a column chart

  • Thread starter Thread starter Haigy
  • Start date Start date
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.
 
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
 
Back
Top