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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com