Create a Pie Chart from a Pivot Table

Guide: Creating a Pie Chart with Legend Titles Inside the Chart (Microsoft Excel)

✅ How to Create a Pie Chart from a Pivot Table

1. Create Your Pivot Table

• Select your data.
• Go to Insert → PivotTable.
• Place the category field (e.g., Item) in the Rows area.
• Place the same field in the Values area (should default to Count of Item).

2. Select the Pivot Table Summary Data

Highlight only the summarized rows (excluding the Grand Total and headers).

Example:

Apples       3 

Bananas      2 

Oranges      1

3. Insert the Pie Chart

• Go to Insert → Pie Chart → Choose a style (e.g., 2D Pie).

✅ How to Show Legend Titles Inside a Pie Chart

Step-by-Step:

1. Click your pie chart to select it.
2. Click the "+" Chart Elements button on the chart's upper-right.
3. Check Data Labels → Click the arrow next to it.
4. Choose More Options (or choose Inside End / Center).

In the "Format Data Labels" Panel:

• Check:
  • ✅ Category Name (to show the legend title)
  • ✅ Value or Percentage (optional)
• Uncheck:
  • ❌ Legend (optional if labels are now inside)
• Label Position:
  • Choose Inside End or Center

🎨 Optional Styling Tips:

• Change label font size, color, or bold for readability.
• Drag overlapping labels manually.
• For small slices:
  • Combine into "Other" category.
  • Or use Data Callouts from Data Label options.

This guide is great for creating presentation-ready charts that show data clearly with labels embedded in each pie slice.