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 kommentar(er)
