Multiple Bar Chart Formats

[Ray]

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.

 

[Jon Peltier]

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