Changing the Body of a Chart

When you add labels, a legend, or annotations to a chart, you change the periphery of the chart, but you don’t affect how the data is displayed. If you do want to change how the data is displayed in the body of the chart, such as by showing or hiding grid lines or changing the scale of the chart, you can do so. Adding grid lines can help viewers make fine distinctions between values, even if they’re viewing the chart from the other end of a conference table, while changing the scale of the chart lets you heighten or downplay the differences among the chart’s values.

Show or Hide Chart Grid Lines

  1. Click the chart you want ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.