Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
Multiple data in series | Charts and Charting in Excel | |||
Charts Line Types for Multiple Data Series not Printing Properly | Charts and Charting in Excel | |||
Creating a High-Low-Close chart with multiple series? | Excel Discussion (Misc queries) |