Based on Steve Bullen's FunChart1 example (in that particular example,
auto-expanding named ranges) I've set up some graphs that used named ranges
as their data source. I copied the worksheet of graphs into a new workbook
and now have global named ranges that match the graphs' original named
ranges (using Jon Peltier's suggestion to use Jan Pieterse et al's Name
Manager v4.0, in which I removed all the sheet named ranges which were
duplicates, leaving me with just one set of global named ranges)

The graphs, which still have their original named range sources, update when
the raw data updates- but I am unable to edit the named range for any
charts. If I click into the source data entry box (series/values) and try to
click out, I get an error message (formula contains an error). The
references are simple (=v11.xls!A_, =v11.xls!B_, etc.) and the named ranges
point to valid ranges of data (and the graphs update when the raw data is
updated).

A_ =INDIRECT("'MAIN DATA'!$BA$" & Graphs!$A$4 & ":$BA$" & Graphs!$B$4)
B_ =OFFSET(A_,0,1)
C_ =OFFSET(A_,0,2)
etc.
(all show the target data range correctly when I click in the range box of
the named range dialogue)

Based on the original problem with the named ranges, is there anything that
might be residually causing problems with the graphs? Any ideas what else I
should check?

Thank you very much,
Keith