T tommy h Nov 19, 2003 #1 How can I create a 100% stacked bar chart with a secondary axis showing data by a line? Thank you for any help
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 Nov 20, 2003 #2 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
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
