Expand Chart Source with New Row(s)
 

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

Expand Chart Source with New Row(s)
 

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



"Rutabaga" wrote:

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