Data Range updating automatically as new data is entered

[mgnrke28]

Hi,
I am wondering if there is a way to make the data range for a series graph
include cells in a column up to the last nonblank cell?

For example, I have a graph with a data range: =Sheet2!$B$2:$E$27
As I add new data to the columns, I'd like the table range (and chart) to
automatically include the new cells.

Is that possible?

Thanks in advance for any help you can provide!

 

[Andy Pope]

Hi,

you could make that range a List (table in xl2007) and base the chart on the
list.
Or you could create a dynamic named range.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy