Interactive Chart?

  • Thread starter Thread starter squishyfrog
  • Start date Start date
S

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
 
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]...
 
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
 
Back
Top