Design: Change Chart Type

The following pages will go through the options on the PivotChart Design Ribbon.

 

Our discussion will include how to edit the Chart Type, Layouts and Styles. We will also Move the PivotChart to a different spreadsheet.

 

Before You Begin: Select the PivotChart.

 

1. Try it: Change the Chart Type

Go to PivotChart Tools ->Design->Type.

Click on: Change Chart Type.

There should be a gallery of Chart Types: Column, Line, Pie, Bar, etc.

 

Try This, Too: Select a New Chart Type

Go to the Column category.

Select: Stacked Column.

 

Click OK. Keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Change Chart Type

PivotChart Tools ->Design ->Type-> Change Chart Type