YEAH!!! I got it. Thanks for your help.
"Andy Pope" wrote:
Hi,
I don't think you can control this when adding extra data.
Once added right click and use the format to change the axis. Also use
the right click to change chart type.
Cheers
Andy
Liz wrote:
I'm running excel 2002. I have a 2 axis chart with lines and columns. When
I add a new series how do I tell it which axis the series is attached to. It
keeps putting them on the lines and I need to add the new series to the
columns
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info