The Insert tab is where you will find some other useful tools that let you add things like a picture, a text box, a pivot table, and more. # Step 3: Click the Insert tab at the top of the window. # Step 2: Select the data that you want to include in the pie chart. 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. One column with a label, and one column with data that will be displayed as the appropriately sized pieces of the pie. For the optimal display of data in a pie chart, it’s ideal to have two columns. This guide will assume that you already have data in a spreadsheet, and that you wish to display that data as a pie chart. The steps in this article were performed in Microsoft Excel 2013. How to Create a Pie Chart in Excel (Guide with Pictures) # Our create table in Excel tutorial can show you how to do this.

Our article continues below with additional information on making a piechart in Excel, including pictures of these steps.Īnother thing you can do with your spreadsheet data is turn it into a table.

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.

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. A pie chart can be a helpful visual aid for displaying values in relation to one another.

How do i make a pie chart in excel