Pinterest Pixel

Pivot Chart Settings

When working with Pivot Charts, sometimes it gets overwhelming with the number of customizations it allows you... read more

Download Excel Workbook
Bryan
Posted on

Overview

Pivot Chart Settings | MyExcelOnline

When working with Pivot Charts, sometimes it gets overwhelming with the number of customizations it allows you to do. Right now I will walk you through the different options so that you can quickly maximize their usage to the fullest!

There are two buttons available for customizing and formatting the Pivot Charts in Excel:

  • Design Tab – It can be used to change the chart type, chart style, select data, add chart elements, etc.
  • Format Tab – It can be used to change chart size, insert shapes, change shape style, etc.

Once you click on the Pivot Chart, you will have these options. Let us go over the Design and Format settings.

Pivot Chart Settings

This is our current Pivot Chart that we will be using to try out the different Pivot Chart settings.

Pivot Chart Settings

Don’t forget to download the Exercise Workbook below and follow along with us!

Download excel workbookPivot-Chart-Settings.xlsx

 

Design Tab

Pivot Chart Settings

The Design tab has the following settings:

  • Add Chart Element – If you want to add/remove additional elements like Axes, Data Labels, Gridlines, Legends, etc. to be displayed in your Pivot Chart, you have these settings:
    • Pivot Chart Settings
  • Quick Layout – This is a handy way to have different types of presentation options. Go over them one by one to determine which will be the most appropriate way to visualize your data.
    • Pivot Chart Settings
  • Chart Styles – You can have fun here with the colors on how your chart will be displayed and match them with your company’s theme colors.
    • Pivot Chart Settings
  • Switch Row/Column – You can use this option to change the way data is plotted in PivotCharts. You can swap the data over the axis with this quickly and revert back when needed.
    Pivot Chart Settings
  • Select Data – You can change the data source of your Pivot Chart using this option.
    Pivot Chart Settings
  • Change Chart Type – There are a lot of different chart types that you can change quickly.
    Pivot Chart Settings
  • Move Chart – If you need to place the Pivot Chart in a different location, you can easily use this option.
    Pivot Chart Settings
See also  Sort an Item Row (Left to Right) With Excel Pivot Tables

 

Format Tab

The Format tab has the following settings:

Pivot Chart Settings

  • Current Selection – You select the specific element of your Pivot Chart on the one you want to modify visually.
    • Pivot Chart Settings
  • Insert Shapes – You can add additional shapes that will help present your data better on top of your Pivot Chart such as arrows and boxes.
    Pivot Chart Settings
  • Shape Styles – You can change the color fill, outline, or even add 3d effects to how it is displayed.
    Pivot Chart Settings
  • WordArt Styles – You can change how text is formatted here with preset styles available.
    Pivot Chart Settings
  • Arrange – You can change the display order, set alignment, or even rotate the selected element.
    Pivot Chart Settings
  • Size – You can change the length and width here.
    Pivot Chart Settings

So, you can use the command buttons present in the Design and Format tab available for PivotCharts to easily customize and format your chart as per your requirement!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

See also  Sort by Largest or Smallest With Excel Pivot Tables

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Pivot Chart Settings | MyExcelOnline
Pivot Chart Settings | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!