Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
RHI
 
Posts: n/a
Default 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?


  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
1 Chart - Different series format chrisabberton Charts and Charting in Excel 2 July 28th 05 04:59 PM
Chart -- How to chart 65536 values in 1 series? kilmaley11 About this forum 0 June 8th 05 11:19 AM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"