Having different Y-axis

[chembeti.aravind]

Hi,
Greetings.

I have 10 sets of data (i.e, 10 series). I have to plot this data with
two different Y-axis types: left side with StackedColumn and right sie
with StackedColumn100 types.

For this first I have plotted all the data. Created one dummy series
(i.e. 11th series) whose values (both x and y) are zero and set it as
secondary axis. Now when I try to set its' 'Type' property with
xlColumnStacked100 it throws exception. (I can not set 'ChartType'
property of this dummy series,; because setting this property will
change all the series objects chart type).

Can somebody help me how to do this?

Thanks in advance

Cheers
Ara

 

[Peter T]

Not sure I understand your data and objective but try this:

Make your chart of 10 stacked-columns, don't worry about an empty 11th

Prepare data in a column of cells (say in L6:L9) with 10 empty columns of
cells to the left.
Drag B6:L6 onto the chart, ie 10 empty cells plus data in L6.
Select the new column in the chart, change it to 100% stacked and set to
secondary axis.
One by one drag the following rows of 11 cells onto the chart, they should
'join' with the 11th 100% stacked column on the secondary axis.

Regards,
Peter T