Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting multiple data series in a bubble chart
Hello,
Would you please help me out in creating multiple data series in bubble chart. I have four parameters as Series: name X axis: value Y axis: value Size : value I can select the individual series and edit all those parameter for individual series, but it's very cumbersome task? do we need to arrange our data in some order to get the direct multiple data series in a bubble chart. Please let me know your comments.... waiting for reply !!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting multiple data series in a bubble chart
On Wed, 22 Aug 2007, in microsoft.public.excel.charting,
Dhananjay said: Would you please help me out in creating multiple data series in bubble chart. I tried to do this recently, and it was a nightmare! In the end, I accepted that the Series name would not read properly, and amended the cell references by hand. Leaving aside the series name, the one-shot arrangement for multiple bubble series should be, IIRC: X1, Y1, S1, Y2, S2, Y3, S3, etc. Where Xn, Yn, and Sn are the X, Y and Size ranges respectively. Series 1, 2, 3 etc. end up sharing the same X range, X1, but they can be manually fixed to each have their own X range afterward. Alternatively, you can abandon the one-shot approach and add them separately: X1, Y1, S1 The first series is created using the wizard. X2, Y2, S2 Further series are added to the chart thus created, using either Copy, Paste Special, or Chart.. Add Series. The series names should then work properly, but I forget whether they're supposed to go over the Y-range or the Size range. -- 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 | |||
Bubble chart with multiple bubble sizes | Excel Discussion (Misc queries) | |||
Multiple series not plotting in their respective data ranges | Charts and Charting in Excel | |||
Bubble Chart Plotting | Charts and Charting in Excel | |||
Bubble chart will not pick X series | Charts and Charting in Excel | |||
Plotting a diagonal in a bubble chart | Charts and Charting in Excel |