Thread: Interactive Chart?

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

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" <squishyfrog.2517qy_1142964900.9738@excelforum-nospam.com>
wrote in message
news:squishyfrog.2517qy_1142964900.9738@excelforum-nospam.com...
>
> 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!

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?

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" <squishyfrog.254sgb_1143131702.2001@excelforum-nospam.com>
wrote in message
news:squishyfrog.254sgb_1143131702.2001@excelforum-nospam.com...
>
> 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