Excel 2007 : Secondary axis alignment

In question.xlsx, you still have the green series linked to another sheet, which I can't see.
Maybe the values are coming from a place you don't expect.

Try recreating this series again. (looks like a horizontal line since the values are so small)

Hi!

I wrote a macro in Visual Basic, as Andy Pope suggested, and it worked. Of course, one of the possibilities is the ratio between max and min on both axis.

Now, next question is: How to print this graph, so it stays as clear as it is now. If i move it to Word, the picture becomes blurry. But i need it in Word, because of the page numbering.

Thanks.

Andy, who da man?