Actual vs Budgeted - Stacked Bar Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawg House Inc - 25 Jul 2007 22:30 GMT

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.

Signature

Dawg House Inc.
"We live in it, therefore, we know it!"

Reply to this Message

Jon Peltier - 26 Jul 2007 04:18 GMT

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
_______

>I am trying to generate a stacked bar chart (of sorts) for the following
> information:
[quoted text clipped - 29 lines]
>
> Thanks in advance.

Reply to this Message