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" <(E-Mail Removed)> wrote in message
news:2AF3F80B-6068-48D2-9E82-(E-Mail Removed)...
> 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!
>