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, click the Themes button, and point to the different themes to see how the appearance of the chart changes with each theme.

  2. Click the theme you want for your chart.

    Change the Theme

Format an Element

  1. On the Chart Tools Format tab, select the chart element you want to format.

  2. Select the style you want to apply to that element.

  3. Click the appropriate button to modify the formatting applied by the style.

  4. If the selection contains text that you want to format using WordArt, click the WordArt style you like. Click the appropriate button to modify the formatting.

  5. Use the Size tools to adjust the dimensions of the selected element.

  6. Click the Format Selection button, and, in the Format dialog box, click the various categories to make changes to the formatting of the element.

  7. Click Close when you’ve finished.

    Format an Element

Tip

Tip

To format text without using WordArt, use the font and alignment tools on the Home tab.

Tip

Tip

You can select an element for formatting by clicking that element in the chart. You can also resize an element by selecting it and dragging its Sizing handles.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset