Dual Information in Bar Graph

D

dbldam7

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??
 
D

dbldam7

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


Echo S said:
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


dbldam7 said:
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??
 
Top