On Tue, 24 Apr 2007, in microsoft.public.excel.charting,
JoeP said:
I have created a column chart using Test as the Data Source, and that works
fine when I first build the Chart.
When I change the content of Sheet1!C1 from 1 to 2 (for example), I expected
the Chart to change but it does not.
I have to go back into the Data Source of the Chart and type =Test in order
for the chart to change.

I'm not sure, but I think you could try typing =Sheet1!Test into the
Data Source of your chart. When I leave off the sheet name, my charts
often don't work at all.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.