You have to program some chart event procedures into your chart. This
article describes chart events and gives some examples:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"squishyfrog"
wrote in message
...

Hello,

I need to create an interactive Excel Line Graph.

What I need to do is be able to click on a datapoint on the graph and
have it take me to the data specific to that point.

For instance if I have a chart that shows how many phone calls are
taken in a week I want to be able to click on a datapoint specific to
the day and be taken to the information for that day.

Any Advice?

SQL FRG


--
squishyfrog