Using pie charts allows you to specify the distribution of data in fragments. It’s easy to create 2D, 3D, or donut-style pie charts in Microsoft Excel – no design knowledge required! Here’s how to do it.
How to create a pie chart in Excel
To create a pie chart in Excel, first open your spreadsheet with the Excel app. We will use the following spreadsheet for this guide:
In your spreadsheet, select the data you want to plot on your pie chart. Do not select any number combination because you may not want to display it on your chart.
Once your data is selected, in the Excel ribbon at the top, click the “Insert” tab.
In the “Insert” tab, from the “Charts” section, select the “Insert pie or donut chart” option (it looks like a small pie chart).
Different pie chart options will appear.
To see what the pie chart will look like for your data, hover your cursor over the chart and a preview will appear.
Once you have decided on a chart, click on it to add it to your spreadsheet.
The chart is now available in your spreadsheet. To change the header of the chart, double click on the header and enter a new name.
You can change the position of the chart in your spreadsheet by dragging and dropping the chart. There is also an option to lock your chart position.
And that’s how you display your Excel data using the slices on the pie!
Related: How to lock chart position in Excel.
How to customize pie chart in Excel
The design of the default pie chart looks good on its own, but you can customize it if you wish.
To do this, click on your chart to get it selected. Then, in the Excel ribbon at the top, click on the “Chart Design” tab.
In the “Chart Design” tab, you’ll find various chart customization options. If you want to change the color scheme of your chart, click on the “Change color” option and select a new scheme.
Similarly, to change the style of your chart, choose a new design from the “Chart Styles” section.
Finally, if you want to use your chart outside of Excel, save the chart as an image file by right-clicking on the chart and selecting “Save as Image”.
And that’s how you personalize your pie charts in Microsoft Excel. If you are creating a handout, you may want to save your Excel sheet as a PDF before printing.
Creating multiple pie charts in your spreadsheet? You can also group your charts with the Excel feature.
Related: How to combine or group pie charts in Microsoft Excel