Change the look of your chart

Change the look of your chart by using a chart style to change colours
Change the look of your chart by using a chart style to change colours.

When you first create your chart, it's in a standard colour. By using a chart style, you can apply different colours to a chart in just seconds.

Click in the chart. Then on the Design tab, in the Chart Styles group, click the More button to see all the choices, and then click the style you want. Some of the styles change just the colour of the columns. Others change the colour and add an outline around the columns, while other styles add colour to the plot area (the area bounded by the chart axes), and some styles add colour to the chart area (the entire chart).

If you don't see what you want in the Chart Styles group, you can get other colour choices by selecting a different theme. Click the Page Layout tab and then click Colours in the Themes group. When you rest the pointer over a colour, the colour is shown in a temporary preview on the chart, which is different from what happens when you look at a chart style. You see the colour's effect before you apply it, saving you the step of undoing it if you don't like it. Click the one you like to apply it to the chart.

Important: Unlike a chart style, the colours from a theme will be applied to other elements you might add to the worksheet. For example a table, or a cell style such as a heading, will take on the colours of the theme applied to the chart.

Previous Next

Share this page with your friends