Hi,

I have bubble charts (up to 30 with 35 points each) that I need to format with leader lines to each bubble. As you can imagine, this becomes pretty tedious...

I already have some VBA to attach the data points, but was wondering if anyone knew how to tell excel to draw a line from the bubble to the data point (the data points are all associated with the bubbles).

I don't know where to start, any advice is appreciated!

Thanks

Edit: this is for excel 2010, I think excel 2013 has this capability, but my office doesn't have that yet. I'm also not allowed to install 3rd party software, unfortunately.