Update Chart Source Range When Adding New Row

[Rutabaga]

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...

 

[Don Guillett]

Make a defined name for your ranges
insert>name>name colA>in the formula box =offset($a$1,0,0,counta($a:$a),1)
use the defined name
or use edit replace to modify your formulas en masse.