Dynamic range as chart data source

B

BillS

[Excel 97]

Is it possible, without VBA, to create a chart which will change alon
with a dynamic data source (ie a variable size range)?

It seems that if you enter a dynamic formula (or name of a dynami
range) as the data source in a chart it will accept it initially, bu
converts it to a fixed size range.

Thanks

Bil
 
Top