Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Phil
 
Posts: n/a
Default Is there a quick way of assigning multiple series to a bubble char


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Each series requires a three-column block of cells, one each for X, Y, and bubble
size. Select the block for the first series and create the chart. Select the block
for the second series, copy it, select the chart, use Edit menu - Paste Special to
add the data as a New Series, with categories in the first column. Repeat as needed.

If the series share the X values, you can use this sequence of columns:

X Y1 B1 Y2 B2 Y3 B3

where X is the column of shared X values, Yi is the column of Y values for the ith
series, and Bi is the column of bubble sizes for the ith series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Phil wrote:

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
Creating a High-Low-Close chart with multiple series? The Chad Charts and Charting in Excel 3 June 7th 07 06:32 PM
Multiple data in series Ann Kelley Charts and Charting in Excel 11 October 5th 05 01:17 AM
Charts Line Types for Multiple Data Series not Printing Properly Seanb Charts and Charting in Excel 0 August 22nd 05 06:35 PM
Creating a High-Low-Close chart with multiple series? The Chad Excel Discussion (Misc queries) 0 May 2nd 05 10:19 PM


All times are GMT +1. The time now is 11:58 PM.

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

About Us

"It's about Microsoft Excel"