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 chartadd
data. When I use chartadd data for the third line, I lose the first line.
Is two the max or am I doing something wrong?
Thanks
--
al

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"al" wrote in message
...
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
chartadd
data. When I use chartadd data for the third line, I lose the first
line.
Is two the max or am I doing something wrong?
Thanks
--
al

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






"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"al" wrote in message
...
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
chartadd
data. When I use chartadd data for the third line, I lose the first
line.
Is two the max or am I doing something wrong?
Thanks
--
al

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"billbrandi" wrote in message
...
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






"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"al" wrote in message
...
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
chartadd
data. When I use chartadd data for the third line, I lose the first
line.
Is two the max or am I doing something wrong?
Thanks
--
al