Prev: Updating from 2003 to 2007: axis labels overwriting
Next: Stacked column in 3D
From: Sue S, Melbourne Sue S, on 31 May 2010 01:39
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
From: Bernard Liengme on 31 May 2010 08:59
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

"Sue S, Melbourne" <Sue S, Melbourne(a)discussions.microsoft.com> wrote in
message news:8D04016B-A2B8-47FA-B19F-9848B6C1CB81(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Updating from 2003 to 2007: axis labels overwriting
Next: Stacked column in 3D