100% stacked chart and secondary axis

How can I create a 100% stacked bar chart with a secondary
axis showing data by a line?

Thank you for any help

Tommy -

Plot all your data as 100% stacked column. Then right-click the one
series you want to switch, choose Chart TYpe from the pop up menu, and
select Line. To put this line on the other axis, double click on it,
and on the Axis tab, select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

tommy h wrote:

> How can I create a 100% stacked bar chart with a secondary
> axis showing data by a line?
>
> Thank you for any help