Data Analysis with Microsoft Excel: Updated for Office 2007

100 Excel

axis scale goes

from 50 to 100

in steps of 5

Figure 3-16
Revised scale
for the y axis

EXCEL TIPS

You can display the axis scale in units of thousands, millions,

and billions by selecting the appropriate options from the Axes

button.

You can display values on a log scale by selecting the Show Axis

with Log Scale option on the Axes button.

Working with Gridlines and Legends

Another chart object that appears in the graduation scatter plot is gridlines.

Gridlines are vertical or horizontal lines that match up with the major and

minor units on the x and y axes. Gridlines can make it easier to line up data

values within the scatter plot. By default, Excel will open a scatter plot with

horizontal gridlines matching the major units on the y axis. You can add or

remove major and minor gridlines from scatter plots using the commands

on the Chart Tools ribbon. Try this by adding vertical gridlines to the gradu-

ation percentage scatter plot.

•

•