Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 -- squishyfrog ------------------------------------------------------------------------ squishyfrog's Profile: http://www.excelforum.com/member.php...o&userid=32685 View this thread: http://www.excelforum.com/showthread...hreadid=524888 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Interactive Chart?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Interactive Chart?
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Interactive Chart?
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Interactive Chart?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Interactive Chart Data? | Excel Discussion (Misc queries) |