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.
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:
