Bubbble chart -How to automatically add series names, X, Y values

[Guest]

I have about 200 + entries that needs to be plotted in a Bubble Chart
Is there a way to automatically add in series names, X, Y and Bubble Size to
plot the bubble chart?

 

[Andy Pope]

Hi,

Not automatically. Instead use a helper column to concatenate the
required text and then use Rob Bovey's free chart labeler addin to link
data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy