The easiest way to make a pie chart in Excel is to select your data and click the quick analysis button. This will open a menu that you can use to add a pie chart to your sheet. Alternatively, you can switch to the Insert tab and add a pie chart this way.
1. Select your data.
2. Click the Quick Analysis button.
3. Switch to Charts then choose Pie.
If you are using data that isn’t a percentage then the data will be interpreted automatically to create an accurate pie chart. This saves you from having to manually work out the percentage or add an addition column to your data just to make the chart.
How to Change the Color of a Pie Chart in Excel
1. Select your pie chart, then switch to the Format tab.
2. Click Format Selection.
3. Select an element you want to change.
4. Go to the Fill & Line options.
5. Click the bucket icon & select a color.
How to Resize a Pie Chart in Excel
You can resize a pie chart by selecting it and dragging in or out one of the corners. By dragging in you will make the pie chart smaller, while dragging out to the right will increase the size of the pie chart.
How to Show Percentages on Pie Chart
1. Select your pie chart then click the plus icon on the side.
2. Check the Data labels box.
3. Click the arrow on the side of the Data Labels text, then select more options.
4. Go to the label options, then enable the Percentage option.
