Excel - Many Pivot Charts: Episode 1346

3,969 views · Published 22 February 2011 · 2:22 · Indexed 6 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

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