2 Variable Stacked Bar Graph? A Challenge!! ;-)

[inthenetguy]

Hi everyone--

Here's a challenge. (Actually, more a desperate plead for help!) I'm trying to create a graph that would have two stacked bars for one variable.

For example, along the left side of my data I have a number of different products. Along the top, I've got Sales Dollars in East, Sales Dollars in Central, and Sales Dollars in West. Also along the top, I've got Customers in East, Customers in Central, and Customers in West. Each cell would have a value for each product.

What I'm trying to do is have two stacked graphs for each product, side by side. (One for sales, and one for # of customers, with the product only being displayed once, if possible.) Each graph would have it's own set of values; i.e. sales along the left side of the chart and # of customers along the right.

Is there ANY way to make this happen? I've tried just about everything I can think of. Any help would be REALLY appreciated!

Thanks in advance!
Mike

[Jay Petrulis]

Hi Mike,

Examples are found on these two websites. Both have downloads available. I think Stephen's is called FunChart4

http://www.stfx.ca/people/bliengme/ExcelTips

http://www.BMSLtd.co.uk

HTH,
Jay