Hi All

I have a dynamic range name that includes all my chart data including
rows and columns as the number of both change a daily basis. So one
day I will have three row series and four columns and another six
series and two columns of data.

I can tell my chart to show all the data by setting the data range to
my dynamic name and that works fine but it converts the dynamic name
to row and column references and forgets the dynamic part for the next
day. I then have to manually perform the same set the next day so that
it charts all the series and data again.

I would like to automate this in VB but this is complicated as all my
charts live on a separate sheet and it is painful in VB to work out
which chart should have which dynamic range name.

How can I get my charts to remember the dynamic range name and not
convert to rows and columns?

If this is not possible what is the best practice to loop over all my
charts and reset their data to the appropriate range name?

At the moment my approach is:
* name each chart the same as the dynamic range name
* loop through the charts on my chart sheet, read its name then set
its data to the same dynamic range name

This is quite involved and not very robust or intuitive. What is the
best practice?

Thanks for any ideas?
Chrisso