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:
Other People Are Reading
Open the pivot chart in Excel. Highlight the parameters of the chart and select "Copy" from the "Home" tab.
Open PowerPoint and navigate to the slide where you want the pivot table to appear.
Click on the downward arrow beneath the "Paste" icon and select "Paste Special."
Choose "Microsoft Office Excel Worksheet Object" from the drop-down menu -- it will be the first option. Click "OK."
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for