Dynamic Chart Question

[shadydeals]

I have some graphs that use named ranges so they update automatically. I would like to create a new graph that graphs the difference of two named ranges. Can I do this without creating another column that explicitly calculates the difference?


Here is what I have now for one graph:
=SERIES(,'Full Summary.xls'!NAME1,'Full Summary.xls'!NAME2,1)

Here is what I want to do (which doesn't work):
=SERIES(,'Full Summary.xls'!NAME1,'Full Summary.xls'!NAME2-'Full Summary.xls'!NAME1,1)

(entering it with CTRL + SHIFT + ENTER doesn't work...)

 

[c_m]

I dont think you can input formula in the reference box for chart.
You will need column for that or if you dont want a column you can create a macro and assign it to chart so that when you click on the chart, it gets updated with the changed values.

 

[shadydeals]

Thanks for the reply. It seems like it would be such a useful feature, I'm surprised there isn't a better solution out there.

 

[shadydeals]

I actually found a pretty good solution.

You can define a new named range as

NAME1-NAME2 and then use that name in the SERIES function.