Multiple Bar Chart Formats
 

How do I combine a bar chart with summary data (for example, 5 categories of
summary data) with a stacked bar chart (a sixth category made up of the parts
that make the summary)?

For example, I have 6 construction projects. I wish to show summary data for
five of the projects (assume they are complete) as a bar chart. I have 4
categories of subtotals that make up each summary. In the case of the sixth
project, wish to show these sub totals as a stacked bar. I want to do this on
one chart.

Multiple Bar Chart Formats
 

I think you want a stacked chart for all of this if I understand your
question. Set up your data like this:

a b c d e

a x

b x

c x

d x

e x

stack x x x x x



a x

b x

c x

d x

e x

stack x x x x x

Add more blocks of rows ("a" through "stack" for each category.

In the first block, the value corresponding to "a" and the first value next
to "stack" are the same, the value corresponding to "b" and the second value
next to "stack" are the same, etc.

Make a stacked column chart with series in columns.

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


"Ray" wrote in message
...
How do I combine a bar chart with summary data (for example, 5 categories
of
summary data) with a stacked bar chart (a sixth category made up of the
parts
that make the summary)?

For example, I have 6 construction projects. I wish to show summary data
for
five of the projects (assume they are complete) as a bar chart. I have 4
categories of subtotals that make up each summary. In the case of the
sixth
project, wish to show these sub totals as a stacked bar. I want to do this
on
one chart.