Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
Hi, I am using some charts embedded in Excel worksheets and I need to trac the selection and mouse events. The Chart element is contained in ChartObject container. Both Chart and ChartObject can be selected b user. When user clicks a chart, the Chart object is selected and th Chart class provides events for selection and mouse actions. If th CTRL key is pressed before clicking the chart, the ChartObject i selected and the context menu and the wire frame are different, th ChartObject does not provide any event because it is an interfac rather than a class. Can you give me a clue how can I track the mous and selection events when the ChartObject is selected? My purpose is t create a custom context menu that will be displayed any time the use right clicks the chart, even if the chart is part o a multipl selection. Thank you, Georg -- george_scortar ----------------------------------------------------------------------- george_scortaru's Profile: http://www.excelforum.com/member.php...fo&userid=2947 View this thread: http://www.excelforum.com/showthread.php?threadid=49178 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
I believe the chart is selected in shape edit mode at that point and as you
say, doesn't fire events. -- Regards, Tom Ogilvy "george_scortaru" <george_scortaru.1zq0ey_1134044102.865@excelforu m-nospam.com wrote in message news:george_scortaru.1zq0ey_1134044102.865@excelfo rum-nospam.com... Hi, I am using some charts embedded in Excel worksheets and I need to track the selection and mouse events. The Chart element is contained in a ChartObject container. Both Chart and ChartObject can be selected by user. When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. If the CTRL key is pressed before clicking the chart, the ChartObject is selected and the context menu and the wire frame are different, the ChartObject does not provide any event because it is an interface rather than a class. Can you give me a clue how can I track the mouse and selection events when the ChartObject is selected? My purpose is to create a custom context menu that will be displayed any time the user right clicks the chart, even if the chart is part o a multiple selection. Thank you, George -- george_scortaru ------------------------------------------------------------------------ george_scortaru's Profile: http://www.excelforum.com/member.php...o&userid=29474 View this thread: http://www.excelforum.com/showthread...hreadid=491784 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
Hi George,
Maybe you could also add a button to the "Shapes" popup commandbar to cater for when chartobject(s) is/are selected. If user clicks your button would need to ensure it only works with charts. To add right click item for whenever user right-clicks on a chart would involve adding (& removing) buttons to all the chart right-click popups, here are some to consider - Chart Floor and Walls Format Axis Format Data Series Format Legend Entry Formula Bar Inactive Chart Object/Plot Plot Area Series Trendline Regards, Peter T "george_scortaru" <george_scortaru.1zq0ey_1134044102.865@excelforu m-nospam.com wrote in message news:george_scortaru.1zq0ey_1134044102.865@excelfo rum-nospam.com... Hi, I am using some charts embedded in Excel worksheets and I need to track the selection and mouse events. The Chart element is contained in a ChartObject container. Both Chart and ChartObject can be selected by user. When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. If the CTRL key is pressed before clicking the chart, the ChartObject is selected and the context menu and the wire frame are different, the ChartObject does not provide any event because it is an interface rather than a class. Can you give me a clue how can I track the mouse and selection events when the ChartObject is selected? My purpose is to create a custom context menu that will be displayed any time the user right clicks the chart, even if the chart is part o a multiple selection. Thank you, George -- george_scortaru ------------------------------------------------------------------------ george_scortaru's Profile: http://www.excelforum.com/member.php...o&userid=29474 View this thread: http://www.excelforum.com/showthread...hreadid=491784 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
In the scenario provided (using ctrl+click), none of the popups in your
second suggestion would appear. -- Regards, Tom Ogilvy "Peter T" <peter_t@discussions wrote in message ... Hi George, Maybe you could also add a button to the "Shapes" popup commandbar to cater for when chartobject(s) is/are selected. If user clicks your button would need to ensure it only works with charts. To add right click item for whenever user right-clicks on a chart would involve adding (& removing) buttons to all the chart right-click popups, here are some to consider - Chart Floor and Walls Format Axis Format Data Series Format Legend Entry Formula Bar Inactive Chart Object/Plot Plot Area Series Trendline Regards, Peter T "george_scortaru" <george_scortaru.1zq0ey_1134044102.865@excelforu m-nospam.com wrote in message news:george_scortaru.1zq0ey_1134044102.865@excelfo rum-nospam.com... Hi, I am using some charts embedded in Excel worksheets and I need to track the selection and mouse events. The Chart element is contained in a ChartObject container. Both Chart and ChartObject can be selected by user. When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. If the CTRL key is pressed before clicking the chart, the ChartObject is selected and the context menu and the wire frame are different, the ChartObject does not provide any event because it is an interface rather than a class. Can you give me a clue how can I track the mouse and selection events when the ChartObject is selected? My purpose is to create a custom context menu that will be displayed any time the user right clicks the chart, even if the chart is part o a multiple selection. Thank you, George -- george_scortaru ------------------------------------------------------------------------ george_scortaru's Profile: http://www.excelforum.com/member.php...o&userid=29474 View this thread: http://www.excelforum.com/showthread...hreadid=491784 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
My understanding is the OP wants to cater for any right click on a chart.
The list of popups in the "second" suggestion may be activated when user clicks somewhere on the chart that was not selected as a chartobject with Ctrl. However to add or correct from my previous post - The "Shapes" bar is only useful if multiple chartobjects (shapes) are selected. For a single chartobject it would be the "Inactive Chart" bar. regards, Peter T "Tom Ogilvy" wrote in message ... In the scenario provided (using ctrl+click), none of the popups in your second suggestion would appear. -- Regards, Tom Ogilvy "Peter T" <peter_t@discussions wrote in message ... Hi George, Maybe you could also add a button to the "Shapes" popup commandbar to cater for when chartobject(s) is/are selected. If user clicks your button would need to ensure it only works with charts. To add right click item for whenever user right-clicks on a chart would involve adding (& removing) buttons to all the chart right-click popups, here are some to consider - Chart Floor and Walls Format Axis Format Data Series Format Legend Entry Formula Bar Inactive Chart Object/Plot Plot Area Series Trendline Regards, Peter T "george_scortaru" <george_scortaru.1zq0ey_1134044102.865@excelforu m-nospam.com wrote in message news:george_scortaru.1zq0ey_1134044102.865@excelfo rum-nospam.com... Hi, I am using some charts embedded in Excel worksheets and I need to track the selection and mouse events. The Chart element is contained in a ChartObject container. Both Chart and ChartObject can be selected by user. When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. If the CTRL key is pressed before clicking the chart, the ChartObject is selected and the context menu and the wire frame are different, the ChartObject does not provide any event because it is an interface rather than a class. Can you give me a clue how can I track the mouse and selection events when the ChartObject is selected? My purpose is to create a custom context menu that will be displayed any time the user right clicks the chart, even if the chart is part o a multiple selection. Thank you, George -- george_scortaru ------------------------------------------------------------------------ george_scortaru's Profile: http://www.excelforum.com/member.php...o&userid=29474 View this thread: http://www.excelforum.com/showthread...hreadid=491784 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I track the chart mouse events?
It appears he knows how to do that except in the stated case:
When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. -- Regards, Tom Ogilvy "Peter T" <peter_t@discussions wrote in message ... My understanding is the OP wants to cater for any right click on a chart. The list of popups in the "second" suggestion may be activated when user clicks somewhere on the chart that was not selected as a chartobject with Ctrl. However to add or correct from my previous post - The "Shapes" bar is only useful if multiple chartobjects (shapes) are selected. For a single chartobject it would be the "Inactive Chart" bar. regards, Peter T "Tom Ogilvy" wrote in message ... In the scenario provided (using ctrl+click), none of the popups in your second suggestion would appear. -- Regards, Tom Ogilvy "Peter T" <peter_t@discussions wrote in message ... Hi George, Maybe you could also add a button to the "Shapes" popup commandbar to cater for when chartobject(s) is/are selected. If user clicks your button would need to ensure it only works with charts. To add right click item for whenever user right-clicks on a chart would involve adding (& removing) buttons to all the chart right-click popups, here are some to consider - Chart Floor and Walls Format Axis Format Data Series Format Legend Entry Formula Bar Inactive Chart Object/Plot Plot Area Series Trendline Regards, Peter T "george_scortaru" <george_scortaru.1zq0ey_1134044102.865@excelforu m-nospam.com wrote in message news:george_scortaru.1zq0ey_1134044102.865@excelfo rum-nospam.com... Hi, I am using some charts embedded in Excel worksheets and I need to track the selection and mouse events. The Chart element is contained in a ChartObject container. Both Chart and ChartObject can be selected by user. When user clicks a chart, the Chart object is selected and the Chart class provides events for selection and mouse actions. If the CTRL key is pressed before clicking the chart, the ChartObject is selected and the context menu and the wire frame are different, the ChartObject does not provide any event because it is an interface rather than a class. Can you give me a clue how can I track the mouse and selection events when the ChartObject is selected? My purpose is to create a custom context menu that will be displayed any time the user right clicks the chart, even if the chart is part o a multiple selection. Thank you, George -- george_scortaru ------------------------------------------------------------------------ george_scortaru's Profile: http://www.excelforum.com/member.php...o&userid=29474 View this thread: http://www.excelforum.com/showthread...hreadid=491784 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
A form to keep track of monetary goals for dated events and offeri | Excel Discussion (Misc queries) | |||
Mouseover or Mouse Move events | Excel Programming | |||
Any mouse events for Worksheets? | Excel Programming | |||
How to use mouse events inside an Excel Sheet ? | Excel Programming |