Hence, click on the Chart and select Chart Elements.Secondly, we will move the Legend to the right side. Afterward, the Pie Chart will look like this.Label Contains → “ Category Name”, and “ Percentage”. Then, the Format Data Labels box will appear.So, click on the Pie Chart and select Chart Elements.At first, we add Data Labels to the Pie Chart.Next, we will add values to the Legend and modify the Pie Chart.Moreover, notice there is Legend without values. Next, from the Insert tab → Insert Pie or Doughnut Chart → select Pie.To begin with, select the cell range B4:C9.Lastly, we input those values from the cell into the Horizontal Axis Labels, which will create an Excel Pie Chart Legend with values. After that, we copy those and “ Paste as Values” into a single cell. Then, we will use the CONCATENATE function to join values into a single cell. In this section, first, we create a basic Pie Chart with our data. Editing Horizontal Axis Labels to Create Excel Pie Chart Legend with Values Therefore, we need to follow some additional procedures to display the Legend with values.ġ. Now, by default, the Legend does not show values beside it. Basically, our dataset represents the sales values by the country for a particular company. Using these data, we will construct a Pie Chart in Excel. To demonstrate our methods, we have selected a dataset with 2 columns: “ Country” and “ Sales”. 2 Handy Approaches to Create Excel Pie Chart Legend with Values
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |