Macro that starts when a graph point is clicked on

  • Thread starter Thread starter Strongpauly
  • Start date Start date
S

Strongpauly

Im trying to create a bubble graph (still the same ones really) tha
when you double click on one of its points it creates a list (probabl
in a new sheet) of the rows that the data came from.

My first major hurdle is trying to get a macro to start when you clic
on the point. Then i need to be able to get the X and Y cooridinate
from the point that was clicked on. I was then thinking about goin
back to the original source and doing a filter of the appropriat
columns.

I can probably work out how to do the filter and copy etc myself, bu
any ideas on how to start the macro and get the coordinat
information?

Is this the right way to go about this?

Any help would be greatly appreciated.

Thanks S
 
Brilliant, thanks a lot. But i am actually creating a lot of thes
graphs and have already written a macro to do so. Do you know of a wa
to include the code that i write automatically in the code of th
chart?

Thanks again
S
 
Back
Top