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
 

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

Top