Jumbabox

Ever wondered how you can create a Pivot Chart and not have it in it’s own sheet? Read on!

Step 1 - Create your PivotChart

I have just created a new Pivot Chart but it is in it’s own sepearate sheet. I need to get this Pivot Chart within a sheet, similar to a normal Excel chart.

Step 2 - Change the Location

After creating your Pivot Chart right click anywhere on the chart and click on the Location… option.

A Chart Location dialog box will pop up asking you where you would like to place your chart.

You can either place your chart as a :

• A new sheet in the workbook
• As an object within a Sheet

I will place mine in the same sheet that contains the Pivot Table which the Pivot Chart is built on. Click the OK button when you are happy with your selection.

Thats it! You can now see that you Pivot Chart is just like a normal Excel chart within a sheet.

Step 3 - Hide your PivotChart fields

Pivot Chart fields can be annoying especially in a presentation so here is how you can hide the fields, make sure you have your Pivot Table toolbar active, if you don’t right click in the top area of Excel and click the Pivot Table option.

This should now display the Pivot Table toolbar. Make sure you have selected your Pivot Chart, on the Pivot Table toolbar click on the Pivot Chart button and finally click on the Hide Pivot Chart field buttons option.

Here is a before and after look at what this option does.

To show the fields again - follow the same process to uncheck the Hide PivotChart Field Buttons option.

Click here to download this example as an Excel Workbook

If you have any problems or questions please comment.

Enjoy!