I track expenses in Excel. I have columns for various categories of
expenses, and a single column for departmental income. When I create a pie
chart to track expenses, it shows what percentage of all of the expenses
comes from each category. I want it to show what percentage OF THE INCOME is
from each category of expense (i.e.: Expense A is 14% of the income, Expense
B is 2% of the income, etc). I'm pretty new to Excel (other than plugging
data into worksheets someone else created). Is this a complicated chart to
set up?

Calculate the desired percentage in adjacent columns and plot those columns.

To get the % of Expense A of the revenue, use the formula =Expense-A-Cell /
Revenue-Cell

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Kendall P" wrote:

I track expenses in Excel. I have columns for various categories of
expenses, and a single column for departmental income. When I create a pie
chart to track expenses, it shows what percentage of all of the expenses
comes from each category. I want it to show what percentage OF THE INCOME is
from each category of expense (i.e.: Expense A is 14% of the income, Expense
B is 2% of the income, etc). I'm pretty new to Excel (other than plugging
data into worksheets someone else created). Is this a complicated chart to
set up?

I have Expense columns C through R. Column T is my Revenue/Income. I
created a row that calculated the percentages I want for each Expense
category. I use that row for my source data values, but they don't display
right in the pie chart. In the pie chart, if you roll the mouse over a
section of the pie, a pop-up shows: "Series 'April 09' Point 'Misc' Value
2.1% (3%)". In the pop-up, 2.1% is the correct percentage I want and 3% is
the percentage of Total Expenses that is under Misc., but the data labels
show the 3% for that section of the pie chart. I want the data label to
show the 2.1% (the percentage of the Revenue/Income for each expense).

"Tushar Mehta" wrote:

Calculate the desired percentage in adjacent columns and plot those columns.

To get the % of Expense A of the revenue, use the formula =Expense-A-Cell /
Revenue-Cell

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Kendall P" wrote:

I track expenses in Excel. I have columns for various categories of
expenses, and a single column for departmental income. When I create a pie
chart to track expenses, it shows what percentage of all of the expenses
comes from each category. I want it to show what percentage OF THE INCOME is
from each category of expense (i.e.: Expense A is 14% of the income, Expense
B is 2% of the income, etc). I'm pretty new to Excel (other than plugging
data into worksheets someone else created). Is this a complicated chart to
set up?