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
------------------------------------------------------------------------
squishyfrog's Profile: http://www.excelforum.com/member.php...o&userid=32685
View this thread: http://www.excelforum.com/showthread...hreadid=524888

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

Perfect! Thanks!


--
squishyfrog
------------------------------------------------------------------------
squishyfrog's Profile: http://www.excelforum.com/member.php...o&userid=32685
View this thread: http://www.excelforum.com/showthread...hreadid=524888

Ok, so I've got a chart event class set up but how do I get a "click"
event to take me to a table containing the data. All the info I have
found toggles charts but doesn't go to specific sections of a table...

Any Ideas?


--
squishyfrog
------------------------------------------------------------------------
squishyfrog's Profile: http://www.excelforum.com/member.php...o&userid=32685
View this thread: http://www.excelforum.com/showthread...hreadid=524888

Find the place in the code where it displays a different chart, and instead
have the code activate the appropriate sheet and scroll to the relevant data
range.

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

Ok, so I've got a chart event class set up but how do I get a "click"
event to take me to a table containing the data. All the info I have
found toggles charts but doesn't go to specific sections of a table...

Any Ideas?


--
squishyfrog