PivotTables · original practice scenario
Insert a PivotChart beside its PivotTable
A Location spending PivotTable already summarises the Expenses source; it needs a chart on its report sheet.
Start here: Windows desktop Excel; active cell inside an existing PivotTable
Do not begin from an ordinary data range: creating a new PivotChart from raw records uses another workflow. Chart filters can affect the linked PivotTable. The Mac path is not inferred.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Windows keys and context
This ribbon sequence opens Insert Chart for the current PivotTable. Choose a chart type and subtype to insert it on that same sheet.
Alt+J,T,C
Windows / Create a PivotChart from a PivotTable. Microsoft reference ↗
Walk through the operation
- Select a cell within the existing Location spending PivotTable.
- Press Alt+J, then T, then C to open Insert Chart.
- Use Tab to reach chart types and Up or Down to choose a type.
- Use Tab to reach subtypes, select one with Left or Right, then press Enter.
Instruction 1 of 4: Select a cell within the existing Location spending PivotTable.
Expected result: A PivotChart linked to the current PivotTable is inserted on the same worksheet.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Select an entire PivotTable report
- Clear a focused PivotTable slicer filter
- Toggle a PivotTable field checkbox
- Group selected PivotTable items
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.