These different chart options are visible when you click the pie button in the Charts group on the ribbon. For example, in the image below I chose to display the data with a percentage of the total overlaid on each pie slice.Įxcel offers a handful of various 2D pie chart options, as well as a 3D pie chart option and a doughnut chart option. If you click the paint brush tool to the right of the chart you will see a couple of other options for how you can display your data. More Information on How to Make Pie Chart in Excel 2013 # Our article continues below with additional information on working with Excel pie charts. My pie chart is shown in the image below. You should now have a pie chart displaying your selected data. If a pie chart isn’t what you need then you can simply click a different chart type and see if it provides the visual data layout you require. Note that this Charts group in the ribbon has a variety of other types of charts or graphs that you could create instead. 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. 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.
0 kommentar(er)
