Creating and editing chart stylesYou can customize chart styles using the chart styles editor. Different options and tabs are available depending on the type of chart the style will be used with.
For example, a Scale tab will display when editing a style for a vertical bar chart, whereas it will not display when creating a style for a pie chart, since scale is not applicable to a pie chart. Thus, before you create a chart style, it is important to know what type of chart the style is being created for. The chart subtype, such as two- or three-dimensional, and stacked or not stacked, will also impact the options on the chart styles editor.
To create or edit a chart style:
2
3 To define general chart style options, click the General tab. Refer to General tab for descriptions of the options available on the tab.
4 To define title options in chart styles, click the Title tab. Refer to Title tab for descriptions of the options available on the tab.
5 To define chart style options for legends displayed in charts, click the Legend tab. Refer to Legend tab for descriptions of the options available on the tab.
6 To define chart style options for labels displayed in charts, click the Label tab. Refer to Label tab for descriptions of the options available on the tab.
7 To define chart style options for chart gridlines, click the Gridlines tab. Refer to Gridlines tab for descriptions of the options available on the tab.
8 To define chart style options for the scales used in charts, click the Scale tab. Refer to Scale tab for descriptions of the options available on the tab.
9 To define chart style options for the data exceptions shown in charts, click the Exceptions tab. Refer to Exceptions tab for descriptions of the options available on the tab.
10 To define 3D settings for 3D chart types, click the 3D Settings tab. Refer to 3D Settings tab for descriptions of the options available on the tab.
11 To define chart style options for chart colors, click the Colors tab. Refer to Colors tab for descriptions of the options available on the tab.
12 To preview the chart style you configured, click the Preview button on the ribbon. The Preview window will open, displaying a sample chart using the chart style you have defined.