Negative dynamic name range in Chart Series

[peter_z]

Hey Guys

I have a few dynamic name ranges in my chart series. The positive ones are all working but one of the name ranges are all negative and it won't work.

Formula:

=SERIES(Reference!$AS$2,,SpreadSheetName.xlsm'!NAMERANGE,1)

NAMERANGE formula = =OFFSET(Reference!$AS$3,0,0,COUNT(Reference!$AN:$AN))

Formula works perfect.

AS3 = -$16429903
-$16616211
-$19535047
-$20886108
-$23182104

AN:AN
5
4
3
2
1

Thanks a million for your help!

 

[peter_z]

Hey guys fixed this problem.

If you are interested you need to go into the graph series and change it in there then it will fix itself.

You can't change it in the Fx ribbon.

Cheers for looking.