If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Actual vs Budgeted - Stacked Bar Chart
I am trying to generate a stacked bar chart (of sorts) for the following
information: Country: countryname Actual Q1: $150,000 Actual Q2: $87,500 Actual Q3: 0 Actual Q4: 0 Budgeted: $1,775,000 *I have multiple countries as well - but if I can sort out one, I'll be fine* What I'm trying to show is the usage of the Overall Budget by Quarter: ___ ||||| ||||| ||||| ----- |Q2| | | ----- | | |Q1| | | ------ The ||||| part is the unused budget (Budgeted - SUM(Q1:Q4)) Q1 value is the Actual amount above. Q2 value is the Acutal amount above. Q3 and Q4 would both have 0 values. Is there a way to set this up to achieve what I'm looking for? I know its possible, the question is, How? Thanks in advance. -- Dawg House Inc. "We live in it, therefore, we know it!" |
#2
|
|||
|
|||
Actual vs Budgeted - Stacked Bar Chart
You need to have five items to plot, plus the budget, plus the category
label. So you need a seven-column table. Column 1 is the category label (i.e., the country). Columns 2-5 are the actuals for Q1-Q4. Column 7 is your total budget, and column 6 is the budget minus the sum of the actuals. Make the stacked plot using columns 1-6, making sure the first column is used for category (X axis) labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dawg House Inc" wrote in message ... I am trying to generate a stacked bar chart (of sorts) for the following information: Country: countryname Actual Q1: $150,000 Actual Q2: $87,500 Actual Q3: 0 Actual Q4: 0 Budgeted: $1,775,000 *I have multiple countries as well - but if I can sort out one, I'll be fine* What I'm trying to show is the usage of the Overall Budget by Quarter: ___ ||||| ||||| ||||| ----- |Q2| | | ----- | | |Q1| | | ------ The ||||| part is the unused budget (Budgeted - SUM(Q1:Q4)) Q1 value is the Actual amount above. Q2 value is the Acutal amount above. Q3 and Q4 would both have 0 values. Is there a way to set this up to achieve what I'm looking for? I know its possible, the question is, How? Thanks in advance. -- Dawg House Inc. "We live in it, therefore, we know it!" |
Thread Tools | |
Display Modes | |
|
|