Pivot Chart Styles

How to Apply PivotChart Styles in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Pivot Chart Styles

Built-in PivotChart styles allow you to adjust the format of several chart elements all at once. Styles allow you to quickly change colors, shading, and other formatting properties.

Apply a PivotChart Style

  1. Select the PivotChart.
  2. Click the Design tab.

    The Chart Styles group of the Design tab shows a few of the available styles. You’ll have to expand the gallery to see all the style options.

  3. Click the Chart Styles More button.
    Apply a PivotChart Style

    A gallery appears displaying all the available chart styles. The styles available in the gallery will vary depending on the type of PivotChart you’re using.

  4. Select a new style.
    Apply a PivotChart Style

The new style is applied to the PivotChart.

Change Chart Colors

If you like a PivotChart style but not the colors that come with it, you can choose a different color scheme.

  1. Click the Change Colors button on the Design tab.

    A menu of color schemes displays. The color options are broken into two categories: Colorful and Monochromatic. You can hover over an option in the menu to see what it will look like before selecting it.

    The color schemes in the list coordinate with the theme that’s applied to the workbook.

  2. Select a new color set.
    Change Chart Colors

The new colors are applied to your PivotChart.