Using named ranges in dynamic charts (excel 2007)
OssieMac,
Well, the saga continues. I tried shortening the names to 'tlab' and 'tval'
but my formula never shows up in the original workbook. I even deleted all
the other ranges, all charts, saved, reopened, created a brand new chart with
the shortened name formula. Then saved, reopened, and no formulas. Below is
the series formula:
=SERIES('TotRev'!$J$4,'WFG Finances.xlsx'!tlab,'WFG Finances.xlsx'!tval,1)
I even changed the name of the worksheet to be shorter with no spaces. Then
even renamed the entire workbook to something short with no spaces.
The workbook had a password to open, and I even removed that to no avail.
There's something in there somewhere it doesn't like. I'm going to keep
playing with it. Will let you know what I find.
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
|