Interactive Chart?

[squishyfrog]

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 an
have it take me to the data specific to that point.

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

Any Advice?

SQL FR

 

[Jon Peltier]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[squishyfrog]

Perfect! Thanks

 

[squishyfrog]

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 hav
found toggles charts but doesn't go to specific sections of a table...

Any Ideas

 

[Jon Peltier]

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" <[email protected]>
wrote in message
news:[email protected]...