If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
timeline chart within a scatter plot
I have an excel scatter plot that displays some point information when
the mouse cursor hovers over the data point. The information displayed are beginning and end time for different events that occured for that particular data point. What I would like to do now is be able to chart a timeline chart that will display the different time event when I click on a datapoint. Has anyone done anything similar to this? A chart that can generate another chart in excel? Thanks, |
#2
|
|||
|
|||
timeline chart within a scatter plot
You can use the click event to trigger a VBA procedure that creates the
second chart. Here's an article about chart events: http://www.computorcompanion.com/LPMArticle.asp?ID=221 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Laoballer" wrote in message ... I have an excel scatter plot that displays some point information when the mouse cursor hovers over the data point. The information displayed are beginning and end time for different events that occured for that particular data point. What I would like to do now is be able to chart a timeline chart that will display the different time event when I click on a datapoint. Has anyone done anything similar to this? A chart that can generate another chart in excel? Thanks, |
#3
|
|||
|
|||
timeline chart within a scatter plot
On Mar 16, 9:47*am, "Jon Peltier"
wrote: You can use the click event to trigger a VBA procedure that creates the second chart. Here's an article about chart events: http://www.computorcompanion.com/LPMArticle.asp?ID=221 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/ _______ "Laoballer" wrote in message ... I have an excel scatter plot that displays some point information when the mouse cursor hovers over the data point. *The information displayed are beginning *and end time for different events that occured for that particular data point. *What I would like to do now is be able to chart a timeline chart that will display the different time event when I click on a datapoint. *Has anyone done anything similar to this? *A chart that can generate another chart in excel? Thanks, Would I be able to use the click event to query an ms access database to retrieve the data for the time line chart into another sheet in the excel file and then create the timeline chart? I also forgot to mention that the parent excel scatter plot is generated using an access program to retrieve the data then do the charting in excel. Thanks, |
#4
|
|||
|
|||
timeline chart within a scatter plot
The click event triggers any code you want it to. The code can query a
database or email the White House. Whatever you're clever enough to code. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Laoballer" wrote in message ... On Mar 16, 9:47 am, "Jon Peltier" wrote: You can use the click event to trigger a VBA procedure that creates the second chart. Here's an article about chart events: http://www.computorcompanion.com/LPMArticle.asp?ID=221 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/ _______ "Laoballer" wrote in message ... I have an excel scatter plot that displays some point information when the mouse cursor hovers over the data point. The information displayed are beginning and end time for different events that occured for that particular data point. What I would like to do now is be able to chart a timeline chart that will display the different time event when I click on a datapoint. Has anyone done anything similar to this? A chart that can generate another chart in excel? Thanks, Would I be able to use the click event to query an ms access database to retrieve the data for the time line chart into another sheet in the excel file and then create the timeline chart? I also forgot to mention that the parent excel scatter plot is generated using an access program to retrieve the data then do the charting in excel. Thanks, |
Thread Tools | |
Display Modes | |
|
|