How use name refs for Source Data?
In Source Data Series Y Values, I want to use name
references (e.g. 'Sheet 1'!Foo:Bar or simply Foo:Bar). Excel 2003 does not seem to permit that. I also tried using a named range (e.g. 'Sheet 1'!FooBar or simply FooBar), to no avail. Is there some way that I can avoid absolute references in the chart Source Data? |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com