Formatting a PivotChart


show more Formatting a PivotChart 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 ...

Formatting a PivotChart

Charts, including PivotCharts, summarize data visually. So you should pay careful attention to the appearance of your chart and the elements it contains. If your organization mandates which color schemes you need to use for external or internal documents, you should also ensure your PivotCharts conform to those production standards. If you want to change the look of your PivotChart, then first you should click the PivotChart so that it's active and then you can make a number of changes. If you want to change your PivotChart's chart style, you can do that by clicking the Design contextual tab and then clicking the More button in the Chart Styles gallery and then selecting the style that you want to apply.

In this case, I will select the Style here, which is called Style 42. When I click it, Excel updates the formatting of the PivotChart. You can also format individual chart elements. So let's say for example that I want to change the formatting of the title, which is Revenue. I ...

Formatting a PivotChart
Video duration: 3m 35s 3h 43m Intermediate

Viewers:

Formatting a PivotChart 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 ...