Chapter 3 Working with Charts 101To add vertical gridlines:1 With the chart still selected, click the Gridlines button from the Axes
group on the Layout tab of the Chart Tools ribbon, click Primary
Vertical Gridlines and then click Major Gridlines.
As shown in Figure 3-17, vertical gridlines are added to the scatter plot.Figure 3-17
Adding vertical
gridlines
You can edit the format of the gridlines by clicking More Primary Grid-
lines Options command found on the menu of commands for each gridline.
By modifying the format, you can change the gridline’s color and style as
well as add drop shadows to each gridline.
The graduation percentage scatter plot also contains a legend. A legend
is a box that identifi es the patterns or colors that are assigned to the data
points in a chart. When you insert a chart, Excel automatically adds a leg-
end. In the graduation percentage chart, the legend appears on the right edge
of the chart, providing the name of the y values (in this case values from the
Graduated column). If there is only one set of data values in the chart you
usually do not need a legend.