Bubble chart twist

[DThib]

I am thinking of doing something I don't know is possible.

I have a bubble chart that is variable in the data it will display. I have data labels on one series to define the components of all the bubbles in the one lane.

I would like to make the data label on a click, go back to the data in another tab that defines it.

So briefly, can anyone help me figure out how to add VBA to data labels that will be changing when the table is updated?

Anyone?

DThib

 

[DThib]

Re-sending for anyone who can answer...