Stacked/clustered column chart with a two vertical axes

[marcos.rodriguez.m]

Much has been discussed here about how to build this chart, but I
haven't found anything explaining the possibility of combining it
with
a second y axis. I want to graph the advertising expenditure and
gross
rating points (what would be the return of investment on advertising)
on television for three diaper brands by day part. Day parts would be
represented by the different colors of which columns will consist.
There are 5 of them: day, early, prime, late and over. For each
brand,
I want that two data columns show. The one to the right will represent
the
expenditure in $ and the one to the left the GRPs.

The thing is, there is an abysmal difference between the scale of $
and GRPs. So I want a secondary axis for each column on the right
side
of each brand. This means that columns # 2, 4, and 6 will be 'ruled'
by the second y axis and the other columns of odd numbers will be
ruled by the primary y axis.


I hope you can get the idea of what I'm trying to do here. Thanks in
advance for your help.

 

[Bernard Liengme]

See Columns on two axes (secondary axis bar chart)
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes

 

[marcos.rodriguez.m]

Thanks for replying, Bernard. I already knew about Peliter's guide to
creating a secondary axis. What's difficult is how to integrate this
in a stacked/clustered column graph. I want the secondary axis
specifically for columns #2, 3 and 4, but it gets complicated because
this columns are clustered. How do I go about this?