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

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/...ry/officeexcel

"Sue S, Melbourne" <Sue S, wrote in
message ...
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