Connecting Bubbles with Arrows

[Marston Gould]

Hi -

I have a bubble chart with 2 series. Each series has one or more
bubbles in it
and each series has an identical # of bubbles.

I'd like to be able to use something like the connector arrows in
AutoShapes
to connect up an arrow from the center of the first bubble in series
one to the center of bubble one in series two.

As I update the data this is based on, I'd like the arrows to move
(repoint)
accordingly.

Is this possible?

Thanks in advance,

Marston Gould
(e-mail address removed)

 

[Jon Peltier]

Hi Marston -

This is not a capability that is built into Excel, but you could use VBA
to draw an arrow that connected the centers of the appropriate bubbles.

- Jon