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?