Multiple Bar Chart Formats

  • Thread starter Thread starter Ray
  • Start date Start date
R

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.
 
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
 
Back
Top