How to Create Pie Chart Legend with Values in Excel

Get FREE Advanced Excel Exercises with Solutions!

When we want to visualize the formation of a particular thing, we use the Pie Chart. For example, we can easily understand the business sales by region from the Pie Chart. In this article, we will show you 2 quick methods to create an Excel Pie Chart Legend with values.


Download Practice Workbook


2 Handy Approaches to Create Excel Pie Chart Legend with Values

To demonstrate our methods, we have selected a dataset with 2 columns: “Country” and “Sales”. Using these data, we will construct a Pie Chart in Excel. Basically, our dataset represents the sales values by the country for a particular company.
Now, by default, the Legend does not show values beside it. Therefore, we need to follow some additional procedures to display the Legend with values.

Excel Pie Chart Legend with Values


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

In this section, first, we create a basic Pie Chart with our data. Then, we will use the CONCATENATE function to join values into a single cell. After that, we copy those and “Paste as Values” into a single cell. Lastly, we input those values from the cell into the Horizontal Axis Labels, which will create an Excel Pie Chart Legend with values.

Steps:

  • To begin with, select the cell range B4:C9.
  • Next, from the Insert tab → Insert Pie or Doughnut Chart → select Pie.

Excel Pie Chart Legend with Values 2

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

Excel Pie Chart Legend with Values 3

  • Next, we will add values to the Legend and modify the Pie Chart.
  • At first, we add Data Labels to the Pie Chart.
  • So, click on the Pie Chart and select Chart Elements.

Excel Pie Chart Legend with Values 4

  • Then, the Format Data Labels box will appear.
  • Then select these:
    • Label Contains → “Category Name”, and “Percentage”.
    • SeparatorComma.
    • Label PositionOutside End.

Excel Pie Chart Legend with Values 5

  • Afterward, the Pie Chart will look like this.

Excel Pie Chart Legend with Values 6

  • Secondly, we will move the Legend to the right side.
  • Hence, click on the Chart and select Chart Elements.
  • Then, select Right from the Legend option.
  • Therefore, our Legend will move to the right side.

Excel Pie Chart Legend with Values 7

  • Now, we will add values to the Pie Chart Legend.
  • Firstly, type the following formula in cell B11.

=CONCATENATE(B5," ","$"&C5,",",B6," ","$"&C6,",",B7," ","$"&C7,",",B8," ","$"&C8,",",B9," ","$"&C9)

Excel Pie Chart Legend with Values 8

This formula joins the values with a single space and dollar signs. Thus, we will have all the values joined in a single cell.

  • Then, press ENTER.

Excel Pie Chart Legend with Values 9

  • Now, copy this value and “Paste as Values” in cell B13.

Excel Pie Chart Legend with Values 10

  • Then, copy the values from cell B13.
  • Afterward, select the Pie Chart.

Excel Pie Chart Legend with Values 11

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

Excel Pie Chart Legend with Values 12

  • After that, the Select Data Source box will pop up.
  • Then, click on Edit under the “Horizontal (Category) Axis Labels” part.

Excel Pie Chart Legend with Values 13

  • Next, another box will appear.
  • Afterward, paste the values inside the Axis label range.
  • Lastly, press OK twice.

Axis Labels

  • Thus, we will create Excel Pie Chart Legend with values and this is what the final step should look like.

Pie Chart 2

Read More: How to Show Legend with Only Values in Excel Chart (with Quick Steps)


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

For the last method, we will use the TEXT function along with the ampersand to create a formula to create the Legend. Then use these to make Excel Pie Chart Legend that contains values.

Steps:

  • At first, select the cell range C5:C9 and type the following formula.

=B5&" " &TEXT(D5,"$0")

Method 2 Formula

Method 2 Formula 2

  • Then, as shown in method 1, create the Pie Chart by selecting the cell range C4:D9.
  • Moreover, we have moved the Legend to the right side and added Data Labels to the Pie Chart.

Method 2 Final Output

Read More: How to Show Percentage in Legend in Excel Pie Chart (with Easy Steps)


Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Conclusion

We have shown you 2 handy approaches for creating a Pie Chart Legend with values in Excel. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq
Rafiul Haq

Greetings! I am Rafiul, an experienced professional with an engineering degree and an MBA in finance. Data analysis is my passion, and I find Excel to be an invaluable tool in this domain. My goal is to simplify complex concepts by providing comprehensive and user-friendly guides on Excel and finance topics, aiming to enhance people's productivity and understanding at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo