PDA

View Full Version : VBA for Dynamic source data for charts



tripnanda
05-22-2012, 04:06 AM
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
05-22-2012, 07:43 AM
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
05-22-2012, 06:38 PM
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.