shadydeals
New Member
- Joined
- Jun 17, 2008
- Messages
- 22
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...)
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...)