It probably didn't remove the line, but converted it to a column. Instead of
using a built-in custom chart type, just make a line chart of all the data,
then select each one you need to change to a column, and use Chart menu
Chart Type to change it. Then double click each one you need on the
secondary axis, and select Secondary on the Axis tab.

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


"Kate" wrote in message
...
Hi

Am having a nightmare with some Excel graphs in 2003.

I've set up a 2 axis line graph with data in % and £000,000's. No problem
with the scaling - sorted! However, when I try and add more than 4 lines
of
data in it removes one of the lines (but leaves it in the Legend and
Source
data).

I've tried doing this s number of ways - even not using the custom graphs
and adding the 2nd axis myself but it still won't have more than 4 lines.

Any ideas?

Thanks in advance