In a Line-column graph on 2 axes, how do I stack the columns?

[Sue S, Melbourne]

In a line-column gaph in Excel 2003, I need to stack 2 columns on the y axis,
leaving the line on the right hand axis unchanged. can i do this in chart
types, or can I set up my data table some way that this will happen
automatically? Any advice would be appreciated. thanks

 

[Bernard Liengme]

I know of no way that the data table can signal the chart engine what type
of chart is needed
The best way would be to make a stacked column chart; select on data sereies
on the cahrt and change it to a Line
Then move it to the secondary axis
You could record all these steps into a macro
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel