stacked/clustered columns with 2 addtional lines

[retrushka]

Does anyone know how to do a stacked/clustered columns with 2 additiona
lines? I saw someone ask this about stacked/clusted columns and i
referred to:
Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/...ips/Columns.htm

I did this but I'm unable to add two lines using another axis since it
already in use. Please help

 

[Jon Peltier]

How are the axes already in use? Are they tied up by the XY series
Bernard uses for the category axis? Do the added lines reflect the same
scale as are used in the columns? You can add them to the primary axis then.

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

 

[retrushka]

I figured out how to do it.

Yes, it has different scales... I used the primary axis and had to foo
around with the labeling of axis to fix it