View Single Post
  #2  
Old May 31st, 2010, 01:59 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default In a Line-column graph on 2 axes, how do I stack the columns?

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