Find out how to make a table in Excel so that you can easily sort, filter, and format the data in your spreadsheet. One other useful way to sort and organize data in Excel is with a table. If you need to use your pie chart in another Microsoft Office application like Microsoft Word or Microsoft Powerpoint then you can right-click on the chart and choose the Copy option, then simply paste it into the desired document.
Choosing the Layout tab provides you with ways to add some needed chart options to the chart, such as labels for your x axis and y axis, you can format data labels, and you can even edit the chart title. If you click the chart you will see a Design tab and a Layout tab at the top of the window. If you choose one of the corner circles then it will expand the chart while keeping everything at scale. Step 3: Right-click on the chart and choose Select Data. Step 2: once you click on a 2-D Pie chart, it will insert the blank chart as shown in the below image. Your chart is going to have some circles on its border that you can drag if you want to make the chart taller or wider. Step 1: Do not select the data rather, place a cursor outside the data and insert one PIE CHART. Some of the other pie charts available after clicking the More Pie Charts menu include “Pie of Pie” and “Bar of Pie.” The layout of these charts will split some of the smaller pie slices from the main pie chart and show that as their own pie chart next to it. How to create a pie chart First, we select the data we want to graph Click Insert tab, Pie button then choose from the selection of pie chart types: Pie. If you need to use a pie chart other than the ones that are shown on the pie chart drop down menu then you can click the More Pie Charts button at the bottom of that menu. These different chart options are visible when you click the pie button in the Charts group on the ribbon. 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. Now copy the Stock Price from B2 to B8 and paste in E2. Here you need to ignore the first date value. Now copy the date values from A3 to A9 and paste in the new column D2. Insert two new columns with the same headers. For the optimal display of data in a pie chart, it’s ideal to have two columns. Now we will follow the below steps to create a step chart in excel. 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