In this step, we will format the Pie of Pie chart. Read More: How to Group Small Values in Excel Pie Chart (2 Suitable Examples) Step-4: Formatting Pie of Pie Chart As a result, the chart has become more visible. Hence, you can see that 4 slices are now present in the second plot of the Pie chart. Here, you can set the Values in second plot according to your choices. Afterward, from the Series Options > set Values in second plot to 4.Next, a Format Data Series dialog box will appear. After that, select the Format Data Series option from the Context Menu.First of all, we will right-click on the first plot of the Pie chart.Therefore, to make the chart more visible and presentable, we will add more value to the second plot. Here, the Above created Pie of Pie chart has more values in the first plot than in the second plot. Read More: Excel Pie Chart Labels on Slices: Add, Show & Modify Factors Step-3: Adding More Value in Second Plot Next, we will click on the Category Name under the Label Options.Īs a result, you can see a Pie of Pie chart with both the Values and Category Name.Moreover, from Chart Elements > click on the rightward arrow of the Data Labels.Ī Format Data Labels dialog box will appear on the left side of the Excel sheet.Next, we will add Category Name to the Pie of Pie chart. Therefore, you can see the Values in the Pie chart. Afterward, from the Chart Elements > click on Data Labels.Furthermore, we will click on Chart Elements, which is a Plus sign situated at the top-right corner of the chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |