View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
emsy85 emsy85 is offline
external usenet poster
 
Posts: 3
Default How can I update multiple excel charts at the same time?

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