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.


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

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 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 an Excel Pie Chart Legend with values and this is what the final step should look like.

Pie Chart 2

Read More: How to Make Pie Chart by Count of Values in Excel


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 an 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: [Solved]: Excel Pie Chart Not Grouping Data


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


Download Practice Workbook


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


<< Go Back To Excel Pie ChartExcel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo