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?