Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
So I have what is likely a simple question. What I am trying to do in excel
2007 is to take my total Income, and from my income see what percentage goes to my expenses. For example I spent roughly 300.00 on gas from my 1500.00 monthly income. Can I get a pie chart to take out what percentage on my mulitple expenses are from my total monthly income? I would like a pie chart showing all of this and the leftover to be 'other'. Can this be calculated or would I need to calculate the percentages first? THANK YOU!!!!!!!!!!!!!!!!!! :)) |
#2
![]() |
|||
|
|||
![]()
Yes, you can definitely create a pie chart in Excel 2007 to show the percentage of your total income that goes towards your expenses.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
Lisa_g said: So I have what is likely a simple question. What I am trying to do in excel 2007 is to take my total Income, and from my income see what percentage goes to my expenses. For example I spent roughly 300.00 on gas from my 1500.00 monthly income. Can I get a pie chart to take out what percentage on my mulitple expenses are from my total monthly income? I would like a pie chart showing all of this and the leftover to be 'other'. Can this be calculated or would I need to calculate the percentages first? You need to do all the calulations on the spreadsheet, then let the chart display the results. Never try to make the charts do the calculating. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add column for percentage o total | Excel Discussion (Misc queries) | |||
how to get a percentage total in excel chart | New Users to Excel | |||
Percentage total may not exceed 100 | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) |