Excel chart problem

[SQLScholar]

Hey all,

Bit of a problem.

I have a chart (line chart) it plots the second line well higher then it should be. So i set up a second axis and it looks fine.

Unfortunately the another graph is doing the same but this is a filled line (dont know what its called, but imagine a line graph with the bit below it filled in).

It wont allow me to get to the section where i set a secondary axis. Any ideas why its doing this? or why its doing the problem in general?

Daniel

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[GlennUK]

I have no problem doing it. Tell us exactly which type of graph this is please.

What does:

or why its doing the problem in general?

mean?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[AndyPope]

Hi,

Sounds like you have selected the stacked line and area charts.

In order to get a series on to the secondary axis you must have minimum of 2 series in the chart.