Hi
When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval?
I've been looking at Excel which seems to choose nice intervals like 100, 200, 500, 1000, 2000 or 5000, etc depending on the numbers involved and the size of the range, but I can't work out what formular or what logic its using to do this.
Anyway it doesn't really matter how Excel is doing it I just need a way to, given some data, work out a suitable interval for the YAxis.
I've been looking all over the net but so far haven't had any luck.
Thank you