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!"

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!"