#### How to add or modify gridlines

Navigate to the Format Chart section for the axis, then choose Gridlines. Use the settings to add or change the axis gridlines, as shown in Figure 16-16. You can modify major or minor division settings.

Figure 16-16 Gridline options

Figure 16-17 Chart with a missing x-axis label

Figure 16-18 Rotated and staggered x-axis labels

To determine which data the legend displays, navigate to the Series section of Format Chart, then use Color By to select Value Series or Categories, as shown in Figure 16-19.

Figure 16-19 Color By option in the Series section

Figure 16-20 Show curve-fitting line option