From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Moving PivotCharts to new sheets - Microsoft Excel Tutorial
From the course: Excel PivotTables: Mastering PivotTables and PivotCharts
Moving PivotCharts to new sheets
- [Narrator] I want to take just a minute to talk about moving pivot charts, specifically on to new sheets, which is something that I actually don't recommend. So you may have noticed that with any chart selected, in your pivot chart tools Design tab, you've got this option for Move Chart at the right of the pane. Also, if you right click, you can see the same option here, right beneath Select Data, so you can move the chart in two different ways. And when you select that option, it gives you a dialog box that allows you to either move it as an object within an existing sheet or as a new sheet on it's own. So right now, it exists as an object within the sheet that we call Pivot, but if we move it to a new sheet, before I press Okay, one thing to note is that I can't undo this change, and it will remove the pivot from it's current location and place it into a new place. So press Okay and now it basically creates a new sheet, called Chart One, where this donut chart now resides. And…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Intro to PivotCharts2m 26s
-
(Locked)
Bar and column PivotCharts4m 13s
-
(Locked)
Pie and donut PivotCharts5m 46s
-
(Locked)
Clustered bar PivotCharts3m 25s
-
(Locked)
Pro tip: Prevent charts from resizing4m 45s
-
(Locked)
Changing chart types on the fly3m 18s
-
(Locked)
Stacked area PivotCharts5m 46s
-
(Locked)
Chart layouts and styles4m 3s
-
(Locked)
Moving PivotCharts to new sheets2m 9s
-
(Locked)
Applying slicers to multiple charts5m 1s
-
(Locked)
Designing interactive dashboards13m 22s
-
-