Automatically updating ranges in charts

Hello,

Can someone help me with this. I have a set of charts
based on a table of data, say, A1-D300. Periodically, I
add data to the bottom of the range. For example, the new
range is A1-D310. I want update the ranges in the charts
so, right now, I either have to click on each data seris
and change D300 to D310 for end of the range or click on
data range and change the end of the range for each series
that way.

Is there a way to get excel to graph to the end of the
range automatically? Maybe there's a function that can go
in to the range instead of "D300" or "D310" or something?

Thanks.

Tom

Hi Tom -

I have a few examples and a lot of links on dynamic charting on my web site:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tom Rietz wrote:

> Hello,
>
> Can someone help me with this. I have a set of charts
> based on a table of data, say, A1-D300. Periodically, I
> add data to the bottom of the range. For example, the new
> range is A1-D310. I want update the ranges in the charts
> so, right now, I either have to click on each data seris
> and change D300 to D310 for end of the range or click on
> data range and change the end of the range for each series
> that way.
>
> Is there a way to get excel to graph to the end of the
> range automatically? Maybe there's a function that can go
> in to the range instead of "D300" or "D310" or something?
>
> Thanks.
>
> Tom
>

Wonderful! Thank you so much. Tom


>-----Original Message-----
>Hi Tom -
>
>I have a few examples and a lot of links on dynamic
charting on my web site:
>
> http://peltiertech.com/Excel/Charts/Dynamics.html
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>Peltier Technical Services
>http://PeltierTech.com/Excel/Charts/
>_______
>
>Tom Rietz wrote:
>
>> Hello,
>>
>> Can someone help me with this. I have a set of charts
>> based on a table of data, say, A1-D300. Periodically,
I
>> add data to the bottom of the range. For example, the
new
>> range is A1-D310. I want update the ranges in the
charts
>> so, right now, I either have to click on each data
seris
>> and change D300 to D310 for end of the range or click
on
>> data range and change the end of the range for each
series
>> that way.
>>
>> Is there a way to get excel to graph to the end of the
>> range automatically? Maybe there's a function that can
go
>> in to the range instead of "D300" or "D310" or
something?
>>
>> Thanks.
>>
>> Tom
>>
>
>.
>

Tom -

Glad to help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tom Rietz wrote:

> Wonderful! Thank you so much. Tom
>
>
>
>>-----Original Message-----
>>Hi Tom -
>>
>>I have a few examples and a lot of links on dynamic
>
> charting on my web site:
>
>> http://peltiertech.com/Excel/Charts/Dynamics.html
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>http://PeltierTech.com/Excel/Charts/
>>_______
>>
>>Tom Rietz wrote:
>>
>>
>>>Hello,
>>>
>>>Can someone help me with this. I have a set of charts
>>>based on a table of data, say, A1-D300. Periodically,
>
> I
>
>>>add data to the bottom of the range. For example, the
>
> new
>
>>>range is A1-D310. I want update the ranges in the
>
> charts
>
>>>so, right now, I either have to click on each data
>
> seris
>
>>>and change D300 to D310 for end of the range or click
>
> on
>
>>>data range and change the end of the range for each
>
> series
>
>>>that way.
>>>
>>>Is there a way to get excel to graph to the end of the
>>>range automatically? Maybe there's a function that can
>
> go
>
>>>in to the range instead of "D300" or "D310" or
>
> something?
>
>>>Thanks.
>>>
>>>Tom
>>>
>>
>>.
>>