Create pivot chart on same worksheet
Windows shortcut
AltF1
This shortcut will embed a pivot chart on the same worksheet as the pivot table. Select a cell in the pivot table first.
No Mac equivalent.
Related videos
The videos below demonstrate this shortcut.
In this video, we look at how to use a pivot table to analyze instrument measurements. This data consists of temperature readings taken in a green house over a period of days.
In this video, we show how to analyze sales data by salesperson, region, and month & year.
In this video, we look at how to use a pivot table to analyze voting data, including winning vote by percentage, and breakdown by age and gender.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.