From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using PivotCharts

Using PivotCharts - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using PivotCharts

When you're working with Pivot Table data, invariably it's about the numbers. And as we work with numbers in Excel sometimes it makes sense to have a chart as well. You can create a Pivot Chart along with a Pivot Table. Also at any time when working with an existing Pivot Table, you can instantly create a chart. For example, if we go to the Slicers sheet in this workbook, Pivot Tables. If we want a Pivot Chart based on the Pivot Tables that's visible simply click within the Pivot Table and press Alt+F1 and there's a chart. One suggestion with Pivot Charts, make them be stacked column. Not always the best solution, but many, many times even when a Pivot Table doesn't seem to have that much data and a Pivot Chart looks fairly crowded as this one does. Let's go to the Design tab in the ribbon when the Pivot Chart is selected and the second button from the right, Change Chart Type, Stacked Column, possibly stacked the bar, Double-Click tends to create a cleaner looking chart, not so…

Contents