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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920