Thread
:
In a Line-column graph on 2 axes, how do I stack the columns?
View Single Post
#
2
May 31st, 2010, 01:59 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
Posts: 516
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
Bernard Liengme
View Public Profile
View message headers
Find all posts by Bernard Liengme
Find all threads started by Bernard Liengme