LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default change source data in multiple charts

Hi
I have over 30 charts where I need to change the source data and it's taking
ages doing it manually, especially as each chart has 3 or 4 series. Is there
an easy way of doing this, please?
I've tried find and replace, but that doesn;t work
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the source worksheet for 100 charts automatically. Excel Forecaster Charts and Charting in Excel 1 May 31st 08 01:05 PM
Change external data source for multiple worksheets Pivot Tables[_2_] Excel Discussion (Misc queries) 4 July 27th 07 01:50 PM
How do I create charts that change source data automatically? cbalster Charts and Charting in Excel 0 May 26th 06 08:19 PM
extending source data in several charts Mike Charts and Charting in Excel 4 November 29th 05 05:37 AM
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"