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:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks