A pie chart can be a helpful visual aid for displaying values in relation to one another. You may be able to tell relatively how large a number is in comparison to other values in a spreadsheet, but the ability to see each piece of data as an individual “slide” of a pie can be very helpful.
Our tutorial below is going to show you how to take two columns of data in an Excel spreadsheet and show that data as a pie chart.
How to Create a Pie Chart in Excel
The steps in this article were performed in Microsoft Excel 2013. This guide will assume that you already have data in a spreadsheet, and that you wish to display that data as a pie chart. For the optimal display of data in a pie chart, it’s ideal to have two columns. One column with a label, and one column with data that will be displayed as the appropriately sized pieces of the pie. In my example below I am going to be displaying a pie chart that includes a column of months, and a column of the total sales for that month.
Step 1: Open Microsoft Excel.
Step 2: Select the data that you want to include in the pie chart.
Step 3: Click the Insert tab at the top of the window.
Step 4: Click the Pie Chart button in the Charts section of the ribbon, then choose the pie chart style you want to add to your spreadsheet.
You should now have a pie chart displaying your selected data. My pie chart is shown in the image below.
if you click the paint brush tool to the right of the chart you will see a couple other options for how you can display your data. For example, in the image below I chose to display the data with a percentage of the total overlaid on each pie slice.
One other useful way to sort and organize data in Excel is with a table. Find out how to make a table in Excel so that you can easily sort, filter, and format the data in your spreadsheet.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.