How to have two axes with stack bars!!!

[aaronfude]

Hi,

Is the following possible to accomplish on the same chart.

http://www-math.mit.edu/~pavel/howtodothis.png

(What you see above is a composite fake.)


Any suggestions?

Many thank in advnace!

Aaron Fude

 

[bj]

you have two sets of data here

one way to do it

if your data is
A B C
25 3
25 2
25 1
25 3

plot Columns A and B as stacked column chart

add Columns B and C to the chart
Select each of the data sets with the column 3 data and change the axis to
secondary
change the format as you want for each of the axis and for the colors in the
second axis to match the first axis catagories.
in the legend select each of the duplcate legend entries and Clear all.

 

[aaronfude]

Thanks for the response, but we just can't figure it out! Can you show
more specifically how it is done or actually send it to us
([email protected]).

Aaron Fude

 

[Earl Kiosterud]

Aaron,

I was afraid that paste of the data would get distorted. This table will
look properly aligned if your newsreader uses a fixed-width font, like
Courier, for reading.

Allocariom Percentage
Four 25%
Three 25%
Two 25%
One 25%
Four 3
One 2
Two 1
Four 4

Also, I erroneously used 1 in the percentage column (left over from messing
with the numbers), instead of 3, 2, 1, 4, so the right side column in the
picture I included in my earlier post is wrong.