can it be done?

[Guest]

hello,

is there any way to create a 2d or 3d chart with stacked columns which would
display two/three columns of data stacked with two categories for each year?
X axis is the years
Y axis is the amt
Data would be for 1999 two columns
bar 1 (shirts) would be stacked for green and blue
bar 2 (ties) would be stacked for green and blue

i.e.
Shirts 1999 2000
green 2 55
blue 1 85
Ties
green 2 54
blue 25 23

can someone help. thank you.

 

[Jon Peltier]

Try one of the links here to a clustered-stacked column chart:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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