I may not fully understand your reponse but if I did then I'm not sure this
solves my problem. Basically what I do originally is specify something like:

=Data!rChartDates

Where "Data" is the tab that has the data in it. If I go back to the chart's
properties after making this change it has automatically updated the
reference to look like this:

='F&O Analysis v2.1.xlsx'!rChartDates

It will stay with this type of reference until i close the spreadsheet and
reopen. At which point i get the behavior I explained and the reference now
looks like:

=[0]!rChartDates

If i go in and replace the [0] with "Data" then it relinks and becomes
dynamic. THis, however, is not very <idynamic</i if you see what i mean. :^)

"Jon Peltier" wrote:

I have seen a similar problem, not with the original dynamic chart, but with
a copy made of a dynamic chart. If the dynamic names are scoped to the
workbook as yours are, the references to the workbook names are obliterated,
converted to [0]. The corrupted references can only be seen through the Edit
Source Data dialog, because the series formula is not longer displayed.

I discovered two things.

1. If you use worksheet-scoped names, this corruption doesn't occur.

2. If you save, close, and reopen the workbook with corrupted charts, the
corruption has healed itself, and the charts are as good as the originals.

I've also filed a very detailed bug report on this behavior.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ken Snyder" wrote in message
...
I did some googling this weekend and found lots of helpful advice on how to
make dynamic charts with named ranges and OFFSET, INDEX, and MATCH
functions.
Anyway, I was able to successfully create the dynamic charts that I wanted
by
pointing the series data at a named range. For instance the data range
represented on my x-axis is derived from the named variable "rChartDates"
which is defined as:

=OFFSET(allDates,0,MATCH(StartDate,allDates,1)-1,1,MATCH(EndDate,allDates,1)-MATCH(StartDate,allDates,1)+1)

This works fine and when I put a reference into my chart I put the
following:

='F&O Analysis v2.1.xlsx'!rChartDates

This too works fine but when I close the spreadsheet and reopen it it has
lost all dynamic behavior and now the property of the chart looks like
this:

=[0]!rChartDates

Any ideas?