Visualizing Data with PivotCharts

This course explores Excel PivotCharts that display a visual representation of PivotTables. The course shows you how to choose a PivotChart, select the data to visualize and modify the look and feel of the chart to meet your requirements.
Course info
Rating
(10)
Level
Advanced
Updated
Dec 11, 2019
Duration
1h 18m
Table of contents
Description
Course info
Rating
(10)
Level
Advanced
Updated
Dec 11, 2019
Duration
1h 18m
Description

A picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. In this course, Visualizing Data with PivotCharts, you will gain the skills to quickly produce charts to a professional standard, which neatly summarize the associated PivotTable, allowing you to visualize the data and spot any trends within it. First, you will learn what PivotCharts are and the different types of charts available for you to use. Next, you will discover how to create PivotCharts, choose the correct chart type, and finesse the look and feel of the chart. Finally, you will explore how to make the chart truly interactive by adding filters, slicers, and drill-up/drill-down capability, helping you answer all those difficult data-related questions that your coworkers and managers just keep on asking! When you are finished this course, you will have the skills and knowledge to use Excel PivotCharts in order to professionally present your data.

About the author
About the author

Ben is a Microsoft Project, Project Server/Online consultant, and Data Specialist with over 20 years of implementation experience. He has been a Microsoft MVP for nine years, as well as blogging on various project server scenarios, has articles published on the Microsoft Project User Group (MPUG), and is the author of Microsoft Project 2013 Plain & Simple.

More from the author
More courses by Ben Howard
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Ben Howard, and welcome to my course, Visualizing Data with PivotCharts. They say a picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. In this course, Visualizing Data with PivotCharts, you'll gain the skills to quickly produce charts to a professional standard, which neatly summarize the associated PivotTable, allowing you to visualize the data and spot any trends within it. First, you'll learn what PivotCharts are and the different types of charts which are available for you to use. Next, you'll discover how to create PivotCharts and choose the correct chart type and finesse the look and feel of the chart. Finally, you'll explore how to make the chart truly and fully interactive by adding filters, slicers, and drill‑up/drill‑down capability, helping you answer all of those difficult data‑related questions that your coworkers and managers just keep on asking. When you've finished the course, you'll have the skills and knowledge to use Excel PivotCharts in order to professionally present your data. In terms of prerequisites, it would be an advantage if you're familiar and comfortable with manipulating data in PivotTables. I hope you'll join me on this course, Visualizing Data with PivotCharts, at Pluralsight.