ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Macros behind charts (https://www.excelbanter.com/charts-charting-excel/228108-macros-behind-charts.html)

DKS

Macros behind charts
 
Hi,

How can I plug in macros behind charts? If I double click (or single click)
on a chart, I want it to execute some macros. Is it possible?

For example,
if I (double-) click on the X-Axis then I want Macro-1 to execute.
if I (double-) click on the Series then I want Macro-2 to execute.
if I (double-) click on the Y-Axis then I want Macro-3 to execute.

How can I achieve that?

Many thanks in anticipation.

DKS

Macros behind charts
 
After a quick research I found the answers. For somebody else interested to
know then this is where I found them
http://www.computorcompanion.com/LPMArticle.asp?ID=221


"DKS" wrote:

Hi,

How can I plug in macros behind charts? If I double click (or single click)
on a chart, I want it to execute some macros. Is it possible?

For example,
if I (double-) click on the X-Axis then I want Macro-1 to execute.
if I (double-) click on the Series then I want Macro-2 to execute.
if I (double-) click on the Y-Axis then I want Macro-3 to execute.

How can I achieve that?

Many thanks in anticipation.



All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com