Expand Chart Source with New Row(s)

[Rutabaga]

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

 

[Zulfikar Ali --IT Consultant]

Hi,
Solution is simple,
in MS Excel 2003, just select the input range used in Sumproduct() function
and convert to it list
Select Range--> Data Menu -- List Option --> Create List --> OK
OR
in MS Excel 2007, convert it to a table format
Select Range --> Home Tab --> Covert to table --> select any table format

Now reapply Sumproduct() function, the result will be updated automatically
when you type new data on in next row.

GoodLuck

Zulfikar Ali