Exceljet

Quick, clean, and to the point

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.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
Pivot Table Example - Sales by sales person
In this video, we show how to analyze sales data by salesperson, region, and month & year.
Pivot Table Example - Instrument readings
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.
Pivot Table Example - Voting results
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.