Pivot tables is a feature in Excel that affords users the ability to summarize large amounts of data. The charts are interactive; sections can be collapsed or maximized 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.
Video of the Day
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 & 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.