LinkBack URL
About LinkBacks
In your Chart.xls example change the named range B to
=OFFSET(Sheet1!$B$2,0,0,8,1)
In your Chart.xls example change the named range B to
=OFFSET(Sheet1!$B$2,0,0,8,1)
Originally Posted by Andy Pope
It will still work but we need to be creative with the formulas. Here is an example below.
Yes looks like you can use INDIRECT and OFFSET that way
Hi Andy Pope,Yes looks like you can use INDIRECT and OFFSET that way
Just curious did look at the second file I posted? If so I would like to get your opion on that.
Last edited by vane0326; 05-13-2008 at 09:41 AM.
It's fine only the named ranges B and D have static range references.
It's when you change those two to be OFFSET formula that the problems arise.
I mean then second file I attach to this thread. It shows you could only have one Define name range for multiple charts. What do you take on that?
The reason I'm asking you because you have alot experience on charts and I seen your name on various forums.
That approachs would work well if all the chartable data was in the same location on multiple sheets.
One thing to be aware of. The CELL function is not stable when a reference is not used as the second argument.
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
This means all the charts on each sheet will be based on the same data set.
Try this, create a New Window and arrange Horizontally.
Show both Sheet1 and Sheet2 and then press F9. Then switch to the other view and press F9 again. You should see that both charts are running of the same data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks