Hi. I have about a zillion charts to update on a daily basis in the same
worksheet. I wondered if there was a way to update all the charts at once?
Thanks

The charts are presumably based on data in one or more worksheets, so to
update your charts you need to update the worksheets which include the data.
I'm sorry if you find that the answer is as unclear as the question was.
--
David Biddulph

"emsy85" wrote in message
...
Hi. I have about a zillion charts to update on a daily basis in the same
worksheet. I wondered if there was a way to update all the charts at once?
Thanks

Thanks for the response. The charts are feeding from various spreadsheets
which are updated daily with large amounts of data. At the moment I manually
update each chart and extend the data source by one day each day. I wondered
if there was a way of updating all the charts at the same time once the data
is updated.

"David Biddulph" wrote:

The charts are presumably based on data in one or more worksheets, so to
update your charts you need to update the worksheets which include the data.
I'm sorry if you find that the answer is as unclear as the question was.
--
David Biddulph

"emsy85" wrote in message
...
Hi. I have about a zillion charts to update on a daily basis in the same
worksheet. I wondered if there was a way to update all the charts at once?
Thanks

There are a few options.

1. If you're running Excel 2003, define the source data as a List (data
menu). In Excel 2007, Lists were renamed Tables. In both cases, any
formulas, including chart series formulas, which reference the entire column
of a List or Table will update as the list or table adds or removes rows.

2. If you can't do #1, make dynamic charts which have dynamic ranges
defining their data regions. This is covered he

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

3. If the changes are simple, and the sheet names are not too intricate, you
could try the (free) series formula editor on my web site:

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

This is particularly useful if all you have to change is, for example, the
last row number in the source data. It does the active chart or any number
of charts at a time.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"emsy85" wrote in message
...
Thanks for the response. The charts are feeding from various spreadsheets
which are updated daily with large amounts of data. At the moment I
manually
update each chart and extend the data source by one day each day. I
wondered
if there was a way of updating all the charts at the same time once the
data
is updated.

"David Biddulph" wrote:

The charts are presumably based on data in one or more worksheets, so to
update your charts you need to update the worksheets which include the
data.
I'm sorry if you find that the answer is as unclear as the question was.
--
David Biddulph

"emsy85" wrote in message
...
Hi. I have about a zillion charts to update on a daily basis in the
same
worksheet. I wondered if there was a way to update all the charts at
once?
Thanks

Jon - Thanks so much. I already found some info on your website which has
helped.

"Jon Peltier" wrote:

There are a few options.

1. If you're running Excel 2003, define the source data as a List (data
menu). In Excel 2007, Lists were renamed Tables. In both cases, any
formulas, including chart series formulas, which reference the entire column
of a List or Table will update as the list or table adds or removes rows.

2. If you can't do #1, make dynamic charts which have dynamic ranges
defining their data regions. This is covered he

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

3. If the changes are simple, and the sheet names are not too intricate, you
could try the (free) series formula editor on my web site:

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

This is particularly useful if all you have to change is, for example, the
last row number in the source data. It does the active chart or any number
of charts at a time.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"emsy85" wrote in message
...
Thanks for the response. The charts are feeding from various spreadsheets
which are updated daily with large amounts of data. At the moment I
manually
update each chart and extend the data source by one day each day. I
wondered
if there was a way of updating all the charts at the same time once the
data
is updated.

"David Biddulph" wrote:

The charts are presumably based on data in one or more worksheets, so to
update your charts you need to update the worksheets which include the
data.
I'm sorry if you find that the answer is as unclear as the question was.
--
David Biddulph

"emsy85" wrote in message
...
Hi. I have about a zillion charts to update on a daily basis in the
same
worksheet. I wondered if there was a way to update all the charts at
once?
Thanks