Hyperlink axis or plot
 

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

Hyperlink axis or plot
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rominall" wrote in message
...
Is there a way to create a hyperlink to the axis or to a data point?
If so, how?

Hyperlink axis or plot
 

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" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rominall" wrote in message
...
Is there a way to create a hyperlink to the axis or to a data point?
If so, how?

Hyperlink axis or plot
 

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


"Rominall" wrote in message
...
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" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rominall" wrote in message
...
Is there a way to create a hyperlink to the axis or to a data point?
If so, how?