Update Chart Source Range When Adding New Row
 

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

Update Chart Source Range When Adding New Row
 

Make a defined name for your ranges
insertnamename colAin 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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rutabaga" wrote in message
...
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...