Creating links on the bars of a bar graph

[ankur.shanker]

Hello!

I want to provide links on the bars of a bar graph. Say, if a bar graph
has 5 bars, I would like to place a hyperlink in each of those 5 bars.
And each hyperlink would take me to a different worksheet.

Please let me know if this is really possible!

Regards,
Ankur

 

[Jon Peltier]

You can do it using chart events. It requires a little bit of VBA
programming. This article explains how to set up chart events. Where it
shows how to identify the point clicked on by the user (about halfway
through), rather than pop up a message box with information about the point,
activate the desired worksheet.

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon