create pie chart in excel using different data

Step 2: Select the data that you want to include in the pie chart.Įxcel offers a handful of various 2D pie chart options, as well as a 3D pie chart option and a doughnut chart option. 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. 4 Additional Sources How to Make Excel 2013 Pie Charts

Create pie chart in excel using different data