Dual Information in Bar Graph

[Guest]

I have a bar graph showing 4 years of data (each year is a column on the
datasheet). Each year contains 4 bar graphs of data (each bar is a row on
the datasheet). I have been asked to take each bar and show two groups of
number stacked on each other.

Example: 380 styles - 1 bar (cell) currently with 380, new bar needs to be
120 and 260 still contained in 1 bar graph in the stack format as 120 will be
a different color or pattern from 260. I can't go from 1 bar to 2 bars.

Can this be done??

 

[Echo S]

Excel MVP Andy Pope has some instructions on creating this type of
stacked/cluster chart at http://www.andypope.info/ngs/ng28.htm

 

[Guest]

This is what I was looking for, thanks for the help!

Excel MVP Andy Pope has some instructions on creating this type of
stacked/cluster chart at http://www.andypope.info/ngs/ng28.htm

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I have a bar graph showing 4 years of data (each year is a column on the
datasheet). Each year contains 4 bar graphs of data (each bar is a row on
the datasheet). I have been asked to take each bar and show two groups of
number stacked on each other.

Example: 380 styles - 1 bar (cell) currently with 380, new bar needs to be
120 and 260 still contained in 1 bar graph in the stack format as 120 will be
a different color or pattern from 260. I can't go from 1 bar to 2 bars.

Can this be done??