In the Format Data Series dialog, click the drop down list beside Split Series to choose what you want to set the value you want to display in the second pie or bar. For this right click on the chart and choose Format Data Series from the menu.ĥ. You can customize which type of values to moved to the additional chart. How to customize Pie of Pie or Pie of Bar ChartĤ.By default, Pie of Pie charts in Excel takes some values. Now you can add the data labels to the charts which looks like below. Let us see how to Pie of Pie charts in Excel with an example.ġ: Select data for which you want to Draw Pie of Pie or Pie of Bar Chart.Ģ: Go to Insert-> Pie and select Pie of Pie or Pie of Bar Chart.ģ: You will get the chart as shown below. Pie of Pie charts in Excel is used to represent separate tiny slices from the main Pie chart and show them in additional Pie charts.
0 Comments
Leave a Reply. |