View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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.
" wrote:

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