Stacked Column Chart

[Stacy]

I seem to be having the hardest time in the world completing this chart! I
hope someone can help..

Here's what I'm trying to do:

I have a row titled Total amount, then four other rows above it, (for
discussion sake we'll say they are A, B, C, D) the column next to those
titles has the values.

In "A", I've got the number 0
In "B", I've got the number 24
In "C", I've got the number 9
In "D", I've got the number 8

For "Total", I've got 41

I need to show a stacked column chart where:

"Total" is it's own bar.
"A", "B", "C", "D" are stacked.

How do I go about doing this?

[Jon Peltier]

Stacy -

Stagger your data in two adjacent columns:

ABCD Total
A 0
B 24
C 9
D 8
Total 41

Select all of this data, and construct a stacked column chart, with
series in rows. In the first position, A through D are stacked up, and
Total doesn't appear, because it is blank (zero value). In the second
position, only Total shows up because it's the only non-zero value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Stacy wrote:

> I seem to be having the hardest time in the world completing this chart! I
> hope someone can help..
>
> Here's what I'm trying to do:
>
> I have a row titled Total amount, then four other rows above it, (for
> discussion sake we'll say they are A, B, C, D) the column next to those
> titles has the values.
>
> In "A", I've got the number 0
> In "B", I've got the number 24
> In "C", I've got the number 9
> In "D", I've got the number 8
>
> For "Total", I've got 41
>
> I need to show a stacked column chart where:
>
> "Total" is it's own bar.
> "A", "B", "C", "D" are stacked.
>
> How do I go about doing this?