Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubbles with multiple series
Hi everybody,
I am trying to create a bubble chart that has about 10 series. Column A contains the names, column B the x value, column C the y values and column D the size. I currently have to manually add each series in the graph. Is there a way to capture all the series rather than me having to add each series one by one? All though this graph only has ten series, I have have about 13 more of these graphs to create, so adding a series one by one can add up to a lot of time. Any help will be appreciated. Maybe some VBA coding is needed. Thanks Kim |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubbles with multiple series
On Sun, 2 Jul 2006, in microsoft.public.excel.charting,
Kim said: I am trying to create a bubble chart that has about 10 series. Column A contains the names, column B the x value, column C the y values and column D the size. I currently have to manually add each series in the graph. Is there a way to capture all the series rather than me having to add each series one by one? Although this graph only has ten series, I have have about 13 more of these graphs to create, so adding a series one by one can add up to a lot of time. Kim, I think you need to set up your ten series columns in order as follows: x1, y1, size 1, y2, size 2, ... y10, size 10 Then in a separate area which you do not select when you make your chart, Name 1..Name 10, x2..x10 All the series will initially share the first x value, so you will still have to manually change the x values for series 2 to 10, but this should save you some time. Even if, like me, you prefer your charts on a separate sheet, it's worth designing them embedded in the data sheet at first, because then you can drag and drop the ranges, which also saves time and effort. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubbles with multiple series
Hi Del,
I will give your suggestion a try. You would think MS would make adding series to a graph a lot simplier. Thanks Again Kim "Del Cotter" wrote in message ... On Sun, 2 Jul 2006, in microsoft.public.excel.charting, Kim said: I am trying to create a bubble chart that has about 10 series. Column A contains the names, column B the x value, column C the y values and column D the size. I currently have to manually add each series in the graph. Is there a way to capture all the series rather than me having to add each series one by one? Although this graph only has ten series, I have have about 13 more of these graphs to create, so adding a series one by one can add up to a lot of time. Kim, I think you need to set up your ten series columns in order as follows: x1, y1, size 1, y2, size 2, ... y10, size 10 Then in a separate area which you do not select when you make your chart, Name 1..Name 10, x2..x10 All the series will initially share the first x value, so you will still have to manually change the x values for series 2 to 10, but this should save you some time. Even if, like me, you prefer your charts on a separate sheet, it's worth designing them embedded in the data sheet at first, because then you can drag and drop the ranges, which also saves time and effort. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubbles with multiple series
Kim -
This is easy. Select the data for the first series, and create the bubble chart. Now select the data for the second series (3 col wide x N rows high), and copy it. Select the chart, use Paste Special from the Edit menu, and add the data as a new series, using Categories in First Column and if appropriate Series names in First Row. Repeat the Copy-Paste Special steps for each additional series to be added. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kim" wrote in message ... Hi Del, I will give your suggestion a try. You would think MS would make adding series to a graph a lot simplier. Thanks Again Kim "Del Cotter" wrote in message ... On Sun, 2 Jul 2006, in microsoft.public.excel.charting, Kim said: I am trying to create a bubble chart that has about 10 series. Column A contains the names, column B the x value, column C the y values and column D the size. I currently have to manually add each series in the graph. Is there a way to capture all the series rather than me having to add each series one by one? Although this graph only has ten series, I have have about 13 more of these graphs to create, so adding a series one by one can add up to a lot of time. Kim, I think you need to set up your ten series columns in order as follows: x1, y1, size 1, y2, size 2, ... y10, size 10 Then in a separate area which you do not select when you make your chart, Name 1..Name 10, x2..x10 All the series will initially share the first x value, so you will still have to manually change the x values for series 2 to 10, but this should save you some time. Even if, like me, you prefer your charts on a separate sheet, it's worth designing them embedded in the data sheet at first, because then you can drag and drop the ranges, which also saves time and effort. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
How do I plot multiple x-axis series in excel charts | Charts and Charting in Excel | |||
Charts Line Types for Multiple Data Series not Printing Properly | Charts and Charting in Excel | |||
Trendline and multiple data series | Excel Discussion (Misc queries) | |||
Single trendline for multiple series | Excel Discussion (Misc queries) |