software

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: www.excelforum.com/member.php...oamp;userid=32685
View this thread: www.excelforum.com/showthread...hreadid=524888You have to program some chart event procedures into your chart. This
article describes chart events and gives some examples:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______quot;squishyfrogquot; gt;
wrote in message
...
gt;
gt; Hello,
gt;
gt; I need to create an interactive Excel Line Graph.
gt;
gt; What I need to do is be able to click on a datapoint on the graph and
gt; have it take me to the data specific to that point.
gt;
gt; For instance if I have a chart that shows how many phone calls are
gt; taken in a week I want to be able to click on a datapoint specific to
gt; the day and be taken to the information for that day.
gt;
gt; Any Advice?
gt;
gt; SQL FRG
gt;
gt;
gt; --
gt; squishyfrog

Perfect! Thanks!--
squishyfrog
------------------------------------------------------------------------
squishyfrog's Profile: www.excelforum.com/member.php...oamp;userid=32685
View this thread: www.excelforum.com/showthread...hreadid=524888
Ok, so I've got a chart event class set up but how do I get a quot;clickquot;
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: www.excelforum.com/member.php...oamp;userid=32685
View this thread: www.excelforum.com/showthread...hreadid=524888Find 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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______quot;squishyfrogquot; gt;
wrote in message
...
gt;
gt; Ok, so I've got a chart event class set up but how do I get a quot;clickquot;
gt; event to take me to a table containing the data. All the info I have
gt; found toggles charts but doesn't go to specific sections of a table...
gt;
gt; Any Ideas?
gt;
gt;
gt; --
gt; squishyfrog