Hello,

I've made a chart based on 2 columns; specifically, I created a table of
cells with SUMPRODUCT results based on those 2 columns. I did not anticipate
needing to add more rows, but now I have to. Can I set up something
somewhere so that the Source range is automatically updated to include the
new row entries? I don't want to have to manually type in the range, or
expand the range box, for each SUMPRODUCT formula each time I enter a new row.

(I thought I had posted this question last night, but I'm not finding it;
sorry if it's a double post).

Thanks for your help...