Creating links on the bars of a bar graph
 

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

Creating links on the bars of a bar graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ps.com...
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