Hello,

I created a chart based on, among other things, data in 2 columns. The
chart data is pulled from a table of cells in which I've entered SUMPRODUCT
results of the data in those 2 columns. I didn't anticipate adding more rows
to the sheet, but now I have to. This is a hassle because I have to manually
change the ranges in the SUMPRODUCT formula (either by typing or by expanding
the boxes) to include the extra rows when I add them.

What, if anything, can I do (or should I have done) to make the source range
expand automatically to include new rows when they are added to the sheet?

Many thanks...