Skip to main content
SheetTutor.
← Shortcut library

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.

Mac 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.

This catalog has no verified Mac binding for this operation. The steps below describe Windows. Choose Windows to use the walkthrough and recall controls.

Walk through the operation

  1. Select a cell within the existing Location spending PivotTable.
  2. Press Alt+J, then T, then C to open Insert Chart.
  3. Use Tab to reach chart types and Up or Down to choose a type.
  4. Use Tab to reach subtypes, select one with Left or Right, then press Enter.

Expected result: A PivotChart linked to the current PivotTable is inserted on the same worksheet.

Related walkthroughs

Browse all shortcut references →

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.