![how to format your data to make a pie chart in excel how to format your data to make a pie chart in excel](https://contexturesblog.com/wp-content/uploads/2013/11/piechart09.png)
What I want to do is only show categories with a value over 2% in my pie. Step 1: Select the data you want displayed in the Pie chart Step 2: Click the Insert Tab, and then Click the Pie Symbol in the Charts Group Step 3: Click the. I have approximately 50 categories in the data template linked to a pie chart and depending on the unit selected I could therefore have anything from 0-50 categories shown as a percentage in my pie chart.
![how to format your data to make a pie chart in excel how to format your data to make a pie chart in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2018/09/how-make-pie-chart-excel-2013-5.jpg)
Note that the chart object must be selected for the Chart Tools menu. This opens the Select Data Source dialogue box. Next, select Chart Tools > Design > Select Data (Data group). This will create an empty pie chart object on the sheet. I have several graphs linked to a data template - The data in the template changes depending on the selected business unit. Here in example, Pie of Pie chart combined bottom four data points and created a separate Pie chart. To do this, first select the pie chart from the Insert > Charts menu to select one of the pie chart options.