Visualizing Data with PivotCharts

by Ben Howard

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.

What you'll learn

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

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 13 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.

Ready to upskill? Get started