100% stacked chart and secondary axis

T

tommy h

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

Thank you for any help
 
J

Jon Peltier

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
 
Top