Chart Animation VBA Help

[chirayu]

Hi Guys,

It is with regards to the following:

http://datapigtechnologies.com/blog/index.php/excel-hero-and-animated-charts/

I tried modifying the code without fruition.

I wish to be able to edit the code to allow me to have the chart on a separate sheet to the data. My data would be on a hidden sheet and whenever I change the vlookup for my chart, the code would execute for the specified chart.

I have 6 charts in my workbook in sheet 2, so more than likely I will need to replicate the code for all 6 charts.

 

[Luke M]

Hi chirayu,

Here's datapig's file, with chart moved to a separate sheet. Hopefully it can serve as an example.

 

[chirayu]

Thanks Luke. I see that you added this before the specified event

With Worksheets("demo")

 

[Luke M]

Yep...and a period in front of the Range callouts, to trace back to the With. That way code knows where to look.