Excel Charts - Chart Styles



You can use Chart Styles to customize the look of the chart. You can set a style and color scheme for your chart with the help of this tool.

Follow the steps given below to add style and color to your chart.

Step 1 − Click on the chart. Three buttons appear at the upper-right corner of the chart.

Step 2 − Click the Chart Styles and Colors Chart Styles icon. STYLE and COLOR will be displayed.

Style

You can use STYLE to fine tune the look and style of your chart.

Step 1 − Click STYLE. Different style options will be displayed.

Style

Step 2 − Scroll down the options. Point to any of the options to see the preview of your chart with the currently selected style.

Preview of Style

Step 3 − Choose the style option you want. The chart will be displayed with the selected style.

Chart with Selected Style

Color

You can use the COLOR options to select the color scheme for your chart.

Step 1 − Click COLOR. Different color scheme will be displayed.

Color

Step 2 − Scroll down the options. Point on any of the options to see the preview of your chart with the currently selected color scheme.

Preview of Color

Step 3 − Choose the color option you want. The chart will be displayed with the selected color.

Chart with Selected Color

You can change the color schemes through the Page Layout tab also.

Step 1 − On the Page Layout tab, in the Themes group, click the Colors button on the Ribbon.

Step 2 − Select any color scheme of your choice from the list.

Page Layout

You can also customize the colors and have your own color scheme.

Step 1 − Click the option Customize Colors…

Customize Colors

A new window Create New Theme Colors appears. Let us take an example.

Step 2 − Click the drop-down arrow to see more options.

Create New Theme

A small window - Theme Colors appear.

Step 3 − Click Orange Accent 2 as shown in the following screen shot.

Orange Accent 2

Step 4 − Give a name to your color scheme. Click Save.

Name to Color Scheme

Your customized theme appears under Custom in the Colors menu, on the Page Layout tab on the ribbon.

Customized Theme
Advertisements