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

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?

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

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

RHI wrote:
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, Microsoft MVP - Excel
http://www.andypope.info