View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fruitticher fruitticher is offline
external usenet poster
 
Posts: 11
Default 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