updating chart using edit query
 

Hi

I import a column of date into column A which is linked to a chart. When I
update the column of data the chart updates automatically. Great! Except
not all columns of data I import have the same number of items. So I am
forever adjusting the range the chart refers to by clicking the line on the
chart and then pulling the handle on the blue box that surrounds the cells
from the previous data range (eg. A1:A25, and getting the blue box to just
surround the new data range (eg. A1:A20).

Can I get the chart to recognise that I want it to reflect only cells with
data in them (e.g. A1:A20) and ignore cells that had data in them last time
but are now empty (e.g. A22:A25)?

Very grateful for assistance