Need stacked chart help

[wjviveen]

Yeah i have looked at his examples, but could not quite find the righ
one.

I need something like that, but then with only 2 stacked bars (f.i
Europe + Asia)
One that contains 3 variables and one that contains only 2 variables.
One should scale on the Y axes and the other on a secondary Y axes.

Thanks in advance for your help

 

[Jon Peltier]

The example shows how to do it for generalized data. You need to stagger your
specific data appropriately to get the columns to stack on the intended stacks.

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

 

[wjviveen]

When i try to move the data to the secondary axis via the format dialog,
only 1
of these 3 series remains visible. The other 2 that were in that
stacked column
no longer appear in my graph for some reason.

What am i doing wrong ? Is there a way to select them al at once ?

 

[wjviveen]

Andy Pope do you have any solution for this ?
Could you help me in the right direction

 

[Andy Pope]

Hi,

If you want to email me (not the NG) your workbook I will take a look
see.

Cheers
Andy