Replace Data Source of a Chart

  • Thread starter Thread starter aalwazeer
  • Start date Start date
A

aalwazeer

Hi,

Is there a fast way to find the data source in a number of charts and
replace that (w/o going to the data source window and edit)with a new
data source( especialy for chats coppied from another sheet where they
keep their link to the original sheet)
 
One approach is to use Defined Names in your chart series.

instead of Sheet1!A1:A15 use
Sheet1!myrange

than in your code you can use:
ActiveWorkbook.Names.Add Name:="myrange", _
RefersTo:="=Sheet1!A1:A15"

Now just let your code change the range reference and your chart will
change.

steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to identify Chart Source data as range? 3
loop to change source data in Excel Charts 3
Copy charts and remove links to original source data 12
Dynamic chart problem 1
Get Data source in Chart 1
How to Hilight Chart's Source Data? 4
changing the source range of a chart 3
Chart Source when copying sheets to new file. 2

Back
Top