Site icon ExcelNotes

How to Insert a Pivot Chart

Pivot Chart is a great tool to graphically summarize and explore your complicated data, please see below for details to create a simple pivot chart.

Step 1: Click any cell in the data;

Step 2: Click the "Insert" tab from the Ribbon;

Step 3: Click the "PivotChart" command in the "Charts" section;

Step 4: In the new window, click "OK" at the bottom if you want the new chart in a "New Worksheet";

Alternatively, check "Existing Worksheet" before clicking the "OK" button.

Step 5: Drag the "Region" to the "Axis (Categories)" box, and drag "Income" to the "Values" box;

Step 6: You will see a Pivot Table in your worksheet.

Please check here to hide the field buttons in Pivot Chart.

Exit mobile version