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. 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. 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. 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. 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
0 kommentar(er)
