Using named ranges in dynamic charts (excel 2007)
OssicMac,
That's excellent information! Thanks for taking the time.
Yesterday I tried to recreate the spreadsheet, thinking that maybe there was
merely something corrupt in a cell or named range somewhere. But then I spent
all afternoon trying to figure out an error I kept getting about a missing
link to a workbook that never existed. This error only came up after I
created the named range for the labels of my data. No matter the name of the
range, as soon as I created this range and saved/closed the file, upon
reopening I would get the missing link notification. So that got me off track
chasing that down. Never found out what it was though. I had copied a bunch
of cells over and althought I can't find anything I suspect there's something
in a formula somewhere that this new workbook is misinterpreting.
But now I will go back to the original workbook and shorten my range names.
There's always something, isn't there?
Thanks again for all your legwork. Sure does help!
Regards,
fruitticher
"OssieMac" wrote:
Hi again Fruitticher,
I did some testing and found some problems like you described. I think that
I have overcome all of them by shortening the names for the named ranges.
I copied the named ranges you posted and I experienced similar problems
trying to insert them in the formula bar. The first one like you said worked
but the second one would not. On saving, closing and re-opening I had lost
the display of the formula on the formula bar.
I started again with a new worksheet and used shorter names for the named
ranges and it appeared to overcome all the problems.
I then went back to the workbook where the formulas would not display and
re-named the ranges with shorter names in Name Manager. The formulas were not
immediately visible but after saving and re-opening the formulas became
visible. I was then able to insert the new shorter names where previously I
could not.
Also I'm sure that I have seen a message at times something like "the range
is too complex to display" when accessing the ranges by right clicking on the
series and selecting 'Select Data' but I can't replicate that at the moment.
I'll be interested in any further comments that you or anyone else has on
the subject.
Regards,
OssieMac
|