create pie chart in excel from checkbook table

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. That's all there is to it.A pie chart can be a helpful visual aid for displaying values in relation to one another. Make sure it is spelled the same as you have it in your popup.

Type in the name of your new category into column A. To add your new category to the Account Categories table AND have it appear in the chart without having to do anything else, select one of the rows in the middle of the Account Categories table and add a row below it. It is best to make the change before adding any data to the table but sometimes that ship has sailed.Ĭhanging the popup has no effect on the Account Categories table. You can copy the cell and paste it to the rest of the cells but it will set all the categories to the same thing and you'll have to change them all back to what they were.

The rest of the popups will have the old list. Any changes you make affect only the one cell you had selected. You can add items in the end of the list but not in the middle of the list. You'll see the list of things in the popup and you can add, delete, or edit the ones there. To add a new category to the popup menu that pops up in column D of the Transactions table, go to the Cell tab of the Inspector.

Create pie chart in excel from checkbook table