charting multiple lines on secondary axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a line-column chart with 2 axes chart in Excel. I would
like to know if it is possible to put several lines on the secondary axis? I
am able to put one on via the chart wizard and one by clicking on chart>add
data. When I use chart>add data for the third line, I lose the first line.
Is two the max or am I doing something wrong?
Thanks
 
Don't use the built-in custom chart type. Make your chart as a column chart
with all of the data. Select a series you want to convert to a line, and
using Chart menu > Chart Type, change it to a line. Select the next one and
repeat, or press the F4 function key, the shortcut for repeat last action.
Double click a series you want on the secondary axis, and on the Axis tab,
select Secondary. Select the next one and repeat, or press the F4 function
key, the shortcut for repeat last action.

- Jon
 
I have a similar problem except I am using stacked columns with my left Y
axis and trying to add multiple lines with the right Y axis. How would I do
this?

Thanks
Bill Falzone
 
In my suggested protocol below, merely replace "column chart" with "stacked
column chart".

- Jon
 
Back
Top