Dynamic Charts In VBA?

[MikeLanglois]

Hi Chandoo,


I was just wondering if anyone knew a way that a chart like this:


http://www.highcharts.com/demo/line-ajax


(data points highlighting on mouse over) was possible in Excel 2007?


Either by including Javascript, or by writing it in VBA?


Many thanks,

Mike

 

[Luke M]

I think it's certainly doable. These 2 articles seem to get pretty close. Perhaps you could play around a bit with them?

http://www.excelhero.com/blog/2010/05/interactive-advanced-excel-chart.html

http://peltiertech.com/WordPress/highlight-a-series-with-a-click-or-a-mouse-over/

 

[NARAYANK991]

Hi Mike ,


I haven't tried it but it should be possible using the rollover technique , provided the chart is an embedded chart and not on a chart sheet.


Check out the technique by Jordan Goldmeier here :


http://www.keepandshare.com/doc/show.php?i=1454384&cat=1&fclick=y


http://optionexplicitvba.blogspot.in/2011/04/rollover-b8-ov1.html


Narayan

 

[Jordan]

There's also a Google Drive with more examples of the technique:


https://drive.google.com/#folders/0B1OBNnu3ZbL0UVFzLWx1OXk3VEU

 

[NARAYANK991]

Hi Jordan ,


Thanks for the link.


Narayan

 

[Jordan]

@NARAYANK No problem


One last link in case this conversation becomes referenced later. I think Robert Mundigl provides an expert tutorial on the rollover method far better than I ever could:


http://www.clearlyandsimply.com/clearly_and_simply/2012/11/roll-over-tooltips-and-web-actions-on-a-microsoft-excel-dashboard.html

 

[MikeLanglois]

You guys are absolutely awesome. With the links provided, I should be able to tinker around and make exactly what I need!


Thanks very much! :D