Bubble Chart - Multiple Series

**David Brown** · 11-18-2011, 01:08 PM

Hello - if anyone could assist that would be greatly appreciated.

I cannot seem to add additional series into a Bubble Chart. the second series bubbles seem to overwrite, or extend the X-axis values.

I have attached a sample. I have added a comment beside the two rows that I cannot seem to add without screwing-up the chart.

Do I need to set the data set-up in a different format?

I seem to have read somewhere that others had this problem.

Thanking you in advance?

**Andy Pope** · 11-19-2011, 06:21 AM

Simplest thing to do is use the Select Data dialog and assign the correct references.

**David Brown** · 11-19-2011, 11:23 AM

Hello - thanks for getting back. Pardon for confusion, but I am unclear what you mean simply use Select Data and then use the Dialogue Box. When I click on the chart and then open up with Select Data, I am unclear what to do next....it is this process that I have been using. I am not sure whether it is possible to have multiple sets of Bubbles against an X/Y axis.

Please explain what you mean by Dialogue Box.

Thanks in advance
David

**Andy Pope** · 11-19-2011, 11:37 AM

If you look at the example file you will see a couple of pictures of the select data dialog and the data selection dialog for a specific series, displayed when you Edit a series.

Just use the 4 range selectors to define ranges for Name, X, Y and sizes.

**David Brown** · 11-19-2011, 12:33 PM

Hello - thanks for this. It seemed that when I opened the file that you attached initially it did not appear to contain the other series - strange. But I have downloaded and re-opened and it now is apparent.

Thanks/D