How to Make a Pivot Chart Active in a PowerPoint Slide

Written by lara webster
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Pivot Chart Active in a PowerPoint Slide
Excel tables and charts help users organise large amounts of data. (Chart analysis image by Dmitriy Lesnyak from Fotolia.com)

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.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

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

  5. 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.

Tips and warnings

  • 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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.