Adding more series to 2 axis line graph

[Guest]

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

 

[Andy Pope]

Hi,

Once you have a secondary axis all new series get added to that. Is it
possible one of the new series has values that are very small and the
line is in fact at zero or very close to the Axis line? You can use the
up/down arrows to cycle through the chart elements. The name of the
selected item appears in the Name box, next to the formula bar. If you
can select the series this way you can then format the series and put it
on the primary axis.

Cheers
Andy

 

[Jon Peltier]

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