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 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 instrument measurements. This data consists of temperature readings taken in a green house over a period of days.
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.