Formatting a Chart

When you create a chart, Excel uses the default settings for the chart design. You can change the overall appearance of the chart by changing the chart style or by changing the theme. You can also modify the appearance of individual parts of the chart.

Change the Chart Style

  1. Click the chart to select it

  2. On the Chart Tools Design tab, click the style you want for the chart.

    Change the Chart Style

Change the Theme

  1. On the Page Layout tab, with the chart visible, ...

Get 2007 Microsoft® Office System 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.