Pie Chart and percentages
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? |
Pie Chart and percentages
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? |
Pie Chart and percentages
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? |
All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com