Changing a PivotChart layout


show more Changing a PivotChart layout provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Changing a PivotChart layout

When you create a PivotChart, Excel uses a basic layout to determine when and where to display elements. Those elements can include the chart title, a legend representing the data series, and axis titles and labels. The basic layout Excel uses is probably good enough for a quick look at your data, but you will most likely want to change how your PivotChart's elements are arranged before you share your chart with your colleagues. For example, Excel comes with a gallery of chart layouts from which to choose. You can display those layouts by clicking your PivotChart and then on the Design contextual tab, clicking the More button at the bottom right corner of the Chart Layouts gallery.

Then you can click the layout that you want to apply. For this example I'll just click the top left, which is layout number one, and when I do Excel changes the chart's layout. Even if the layout you choose includes elements such as a title or legend, those items either won't appear or will disp...

Changing a PivotChart layout
Video duration: 3m 14s 3h 43m Intermediate

Viewers:

Changing a PivotChart layout provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...