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 show how this shortcut can be used.
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.
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.
