How to Create Pie Chart Legend with Values in Excel: 2 Methods

Method 1 – Editing Horizontal Axis Labels to Create Excel Pie Chart Legend with Values

Steps:

• Select the cell range B4:C9.
• From the Insert tab → Insert Pie or Doughnut Chart → select Pie.

• This basic Pie Chart will pop up. Moreover, notice there is Legend without values.

• Add values to the Legend and modify the Pie Chart.
• Add Data Labels to the Pie Chart.
• Click on the Pie Chart and select Chart Elements.

• The Format Data Labels box will appear.
• Select these:
  • Label Contains → “Category Name”, and “Percentage”.
  • Separator → Comma.
  • Label Position → Outside End.

• The Pie Chart will look like this.

• We will move the Legend to the right side.
• Click on the Chart and select Chart Elements.
• Select Right from the Legend option.
• Our Legend will move to the right side.

• Add values to the Pie Chart Legend.
• Type the following formula in cell B11.

This formula joins the values with a single space and dollar signs. Have all the values joined in a single cell.

• Press ENTER.

• Copy this value and “Paste as Values” in cell B13.

• Copy the values from cell B13.
• Select the Pie Chart.

• From the Chart Design tab, click on “Select Data”.

• The Select Data Source box will pop up.
• Click on Edit under the “Horizontal (Category) Axis Labels” part.

• Another box will appear.
• Paste the values inside the Axis label range.
• Press OK twice.

• Create an Excel Pie Chart Legend with values, and this is what the final step should look like.

Method 2 – Using Combined Formula to Make Excel Pie Chart Legend with Values

Steps:

• Select the cell range C5:C9 and type the following formula.

• Press CTRL+ENTER.
• This will AutoFill the formula to the selected cells.

• As shown in method 1, create the Pie Chart by selecting the cell range C4:D9.
• We moved the Legend to the right side and added Data Labels to the Pie Chart.

Download Practice Workbook

Related Articles

• How to Show Percentage in Excel Pie Chart
• How to Show Percentage and Value in Excel Pie Chart
• How to Show Percentage in Legend in Excel Pie Chart
• How to Show Total in Excel Pie Chart
• How to Create Pie Chart for Sum by Category in Excel
• How to Group Small Values in Excel Pie Chart

<< Go Back To Excel Pie Chart | Excel Charts | Learn Excel