![]() # 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |