Expandable data range for a chart

[thelaxman101]

I import data from either web query or database query so that I can run more
advanced reporting from Excel. The problem is that depending on the source
data, the lists and data tables imported are of different sizes day to day.
Is there a way to set my chart data sources to be expandable so as to fit the
size of the imported data table?

Thanks

 

[Luke M]

Yes, you can do this with named ranges. See Jon Peltier's article on dynamic
charting:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html