Excel - How To Add a Pivot Chart In Excel - Episode 2008

1,806 views · Published 3 September 2016 · 6:06 · Indexed 8 November 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial - Pivot Charts

Welcome to the MrExcel Podcast, where we bring you the best tips and tricks for mastering Excel. In this episode, we will be diving into Pivot Charts, a powerful tool for visualizing data in Excel. Don't forget to subscribe to our MrExcel Excel playlist to stay updated on all our latest videos.

In this netcast, Bill Jelen will be taking you through the process of creating a Pivot Chart in Excel. He will be going into more detail than what is covered in the book, so be sure to follow along and learn some new techniques. This is a great opportunity to enhance your Excel skills and impress your boss with your data visualization abilities.

To start off, Bill admits that he hardly ever uses Pivot Charts, even though they are a great tool. But today, he will be showing you how to create a Pivot Chart step by step. He starts by inserting a Pivot Table and then moving on to creating the chart. He also shares his old school method of creating the Pivot Table first and then the chart, which he finds more efficient.

In this tutorial, Bill will be creating a dashboard with a chart that compares ebook sales to print book sales over the years. He explains that in order to have the years go across the chart, they have to go down in the Pivot Table, which may seem backwards. But don't worry, he will guide you through the process and show you how to change the field settings to display the values as a percentage of the row total.

Once the Pivot Table is set up, Bill shows you how to create a Pivot Chart from it. He then adds some formatting to make the chart more visually appealing, such as removing the legend and adding a chart title. He also shares a useful tip on how to adjust the gap width to make the columns in the chart bigger and easier to read. And finally, he shows you how to get rid of any unwanted elements, such as value lines and years, using the Field Buttons on the Analyze tab.

By the end of this netcast, you will have a better understanding of how to create a Pivot Chart in Excel and how to customize it to suit your needs. This is just one of the many tips and tricks that you can learn from our MrExcel Podcast. Don't forget to check out our other videos and stay tuned for more tutorials on Pivot Charts and other Excel features. And if you want to take your Excel skills to the next level, be sure to grab a copy of Bill's book, "Forty Greatest Tips for Excel 2007". Thanks for watching and we'll see you in the next netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Pivot Charts
(00:16) Detailed explanation of building a Pivot Chart
(00:35) Creating a Pivot Table first and then using it to create a chart
(00:57) Adjusting the Pivot Table layout for desired chart display
(01:07) Creating a stacked column chart to compare data
(01:17) Formatting the Pivot Table to show percentages
(02:02) Creating a Pivot Chart from the Pivot Table
(02:29) Moving the chart to desired location on the dashboard
(02:48) Formatting the chart for desired display
(03:19) Adding a chart title and data labels to the pivot chart
(04:11) Hiding unnecessary elements on the chart
(04:42) Recap of the episode
(05:10) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #pivottable #excelcharts #pivotchart 

This video answers these common search terms:
what is a pivotchart in excel
how to do pivot chart in excel
how to add pivot chart in excel
how to do a pivot chart in excel
how to make pivot chart excel
how to insert pivot chart in excel
how to create a pivot chart in excel
how to create a pivot table chart in excel
how to make an interactive pivot charts in excel
how to create chart from pivot table in excel

Building a pivot chart to summarize a data set
I start with a pivot table.
If you want years to go across the chart, make them go down the Rows area
Change Field Settings to Show Values as a Percentage of Row
Format the pivot table as % with no decimal places
Create the pivot chart
Immediately Cut, Ctrl+Home, Paste
Formatting the chart: 
Adding a Title at the top
Triple click the title to edit in place
Select second series. Ctrl+1. Narrow the Gap Width.
Add Data Labels to only the second series

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153835/

More from this channel