Excel - Many Pivot Charts: Episode 1346
3,969 views · Published 22 February 2011 · 2:22 · Indexed 6 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Creating a Dashboard with Pivot Charts - Solving the Issue of Multiple Charts on One Sheet. Welcome to another episode of the MrExcel podcast. In today's episode, we will be discussing one of the lesser-known features of Excel - Pivot Charts. While I am a huge fan of PivotTables, I rarely talk about Pivot Charts. But thanks to a question from our listener Joe, we will be diving into the world of Pivot Charts today. Joe's question is about getting multiple Pivot Charts on one sheet. He mentions that as he pivots the data, the PivotTable gets wider and runs into the other Pivot Table, making it difficult to update. So, let's take a look at how we can solve this issue. Typically, when we insert a Pivot Chart, it appears on the same sheet as the PivotTable. However, this doesn't have to be the case. You can choose the chart, go to "Move Chart" and select to move it to a new sheet or even an object on a different sheet. In this episode, I will show you how to create a dashboard using this method. I have a dashboard sheet with multiple PivotTables, and I have used the "Move Chart" feature to place the Pivot Charts for each of these tables on the dashboard sheet. This way, you don't have to worry about the PivotTable changing size as you update the Pivot Chart. The charts live on their own sheet and will remain the same size, making it a much more user-friendly option. So, instead of being stuck with the Pivot Chart right next to the PivotTable, you can move it to its own sheet and create a dashboard with all your charts in one place. This is a great way to present your data and make it easier to update and analyze. I want to thank Joe for sending in his question and thank you for tuning in. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time for another episode of the MrExcel podcast. 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) Joe's Issue with Multiple Pivot Charts (00:26) Inserting a Pivot Chart (00:36) Default Placement of Pivot Chart (00:46) Creating a Dashboard with Pivot Charts (01:10) Moving Pivot Charts to a New Sheet (01:35) Benefits of Using a Dashboard (01:45) Pivot Charts on Their Own Sheet (01:55) Advantages of Separating Pivot Charts from Pivot Tables (02:06) 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 This video answers these common search terms: Benefits of separating Pivot Table and chart Changing items on the pivot chart Creating a dashboard Creating a separate dashboard for pivot charts Excel Pivot Charts Insert Pivot Chart Move chart to new sheet Pivot chart size PivotTable and Pivot Chart on same sheet Thanking Joe for the question Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153026/ Today's Question, from Joe: "How can I arrange many Pivot Charts on a worksheet - without the underlying Pivot Tables getting in the way of my Charts?" Bill answers this by setting up a Dashboard Sheet within Episode #1346. Learn Excel from MrExcel!
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