Excel Advanced Charting Pivoted Data
ADVANCED Charting Pivoted Data
Create PivotCharts from existing data add data to the chart pivot the displayed data and work with the Analyze tab.
Charting Pivoted Data Overview
This topic focuses on getting started with PivotCharts. The supplied course outline covers creating a PivotChart from existing data adding data to the chart pivoting data and using the Analyze tab.
A PivotChart provides a chart view of pivoted data and can be adjusted as the underlying analytical view changes.
Essential Terms
Review the terminology used in the PivotChart tasks specified by the course source.
Getting Started with PivotCharts
Start with existing data then create the PivotChart and work with its data and analysis controls.
Core PivotChart Tasks
The source identifies four practical tasks for charting pivoted data.
Create
Create a PivotChart from existing data.
Add Data
Add data to your chart when the displayed information needs to be extended.
Pivot Data
Pivot data to change the way information is arranged and viewed.
Analyze
Use the Analyze tab for PivotChart analysis tasks covered by the course.
PivotChart Workflow
Follow the source sequence from existing data through chart creation and analysis.
Working with the PivotChart
Use the chart as an interactive visual representation of the pivoted data while applying the specific tasks named in the course outline.
Interactive PivotChart Explorer
Explore each PivotChart task included in the supplied source.
Key Takeaways
PivotCharts combine charting with pivoted data so the visual can be worked with as the analytical arrangement changes.
The course sequence is to create a PivotChart from existing data add chart data pivot the data and use the Analyze tab.
The supplied outline lists these four PivotChart tasks and does not provide additional subtopics for this topic.
Knowledge Check
Test your understanding of the PivotChart tasks in the course source.