VBA for Dynamic source data for charts

[tripnanda]

Hi All, I found this link which has code for a Dynamic Charting Range: ww.vbaexpress.com/kb/getarticle.php?kb_id=602#instr Is there a way to tweak this code so, the chart and source data can be on different sheets? I am not a VBA person and any assistance would be appreciated. As this is my 1st post I was unable to post the full link. The link is to this forum where I found it using a google search

[Kenneth Hobs]

Welcome to the forum!

It is easier to help if you attach an example. The more simple the file, the easier it is to help you.

[geekgirlau]

It looks like the code references whatever data range the chart already has - move your chart to a different sheet and test to see if the code still works.