Hyperlink axis or plot

[Guest]

Is there a way to create a hyperlink to the axis or to a data point?
If so, how?

 

[Jon Peltier]

Describe in more detail how this hyperlink will work. Where is the link to
be clicked on, and where does it take you?

- Jon

 

[Guest]

Bar graph w/ people's names as x axis. Each person has their own worksheet
(in the same workbook) with more detailed information. I would like the user
to be able to click either on the name or the data point and take them to
that person's worksheet.

 

[Jon Peltier]

Okay, that makes sense. You need to enable chart events so Excel recognizes
that you've clicked on a data point, and once you've slicked that point it
can go to the target worksheet.

This article describes chart events, and has a simplistic example showing
how to respond to a click on a data point:

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

- Jon