View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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