Data Range updating automatically as new data is entered

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!

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

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mgnrke28" <mgnrke28@discussions.microsoft.com> wrote in message
news:2AF3F80B-6068-48D2-9E82-FF69BD384244@microsoft.com...
> 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!
>