Modifying axis scaling


show more Modifying axis scaling provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Modifying axis scaling

When you're creating a chart, Excel uses numbers on axes and it scales them automatically. In this particular chart here that shows data from rows 4 and 5 on the worksheet over between columns B and G, you can readily see the highest value here; the sales value for June is 330. On the chart the highest value shown is 350. Now if we alter the numbers and we happen to be using certain larger numbers and it depends upon the value of them, Excel will automatically re-scale the chart based on the data, and sometimes the interval as well.

The intervals here are 50. That's probably the reasonable interval. It's not too crowded. Makes the chart more readable, and it's accompanied by gridlines as well. I'm going to change the June value here from 330 to 335, not a big change. As I press Enter, watch the chart. The interval is still the same, 50, but now that chart tops off at 400. Now, rather than playing the game to see when this changes, you can bet that if I change this to what, ...

Modifying axis scaling
Video duration: 3m 50s 3h 36m Intermediate

Viewers:

Modifying axis scaling provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...