We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Make a Pivot Chart Active in a PowerPoint Slide

Updated March 23, 2017

Pivot tables is a feature in Excel that affords users the ability to summarise large amounts of data. The charts are interactive; sections can be collapsed or maximised depending on where a user wants to focus at any given time. Pivot charts can also be a useful tool for PowerPoint users who want a condensed way to display data in a presentation.

Loading ...
  1. Open the pivot chart in Excel. Highlight the parameters of the chart and select "Copy" from the "Home" tab.

  2. Open PowerPoint and navigate to the slide where you want the pivot table to appear.

  3. Click on the downward arrow beneath the "Paste" icon and select "Paste Special."

  4. Choose "Microsoft Office Excel Worksheet Object" from the drop-down menu -- it will be the first option. Click "OK."

  5. Change the size of the chart, if desired, by dragging the corners of the image. Double-click on the image of the pivot chart to make it active. Click on the slide outside of the pivot chart to return it to image format.

  6. Tip

    To activate a pivot chart in PowerPoint, the data source (Excel worksheet) that the chart comes from must be running in the background. If you open the PowerPoint slide without the Excel worksheet open, the pivot chart can only be viewed as an image.

Loading ...

About the Author

Lara Webster

Lara Webster has been writing professionally since 2009. Her work has been featured on Relationships in the Raw, The Nursery Book, Spark Trust and several travel-related websites. Webster holds a Bachelor of Arts in English and a Master of Arts in mass communication and media studies, both from San Diego State University.

Loading ...
Loading ...