Several data series with different categories/labels in one chart

Hi there.

After having checked that no similar issue were reported, I dare putting mine.

I’m struggling putting in a unique scattered diagram/graph data with adequate labels.

This is kind of reccurent problem for risk analysis.

Consider that we have n categories, for each category we have 4 sets of data:

column 1: label

column 2: x

column 3:y

column 4:z

and consider that you need a bubble plot where (x,y) are the coordinates and z the size of the bullet.

What I need to do is to put the label appearing.
It works very fine if you have a unique category.
It’s another story if you need to deal with several categories.

Example
assuming category 1=T, category 2 is F

T1 0.1 0.5 0.05

T2 0.2 0.1 0.02

T3 0.15 0.1 0.015

T4 0.25 0.2 0.05

F1 0.2 0.6 0.12

F2 0.1 0.3 0.03

F3 0.9 0.2 0.18

F4 0.2 0.5 0.1

and you need the bubbles to show T1… T4 and F1… F4 as labels where appropriate.

any kind of help will be appreciated.

Best

Moon

Please take a look if it is what you want.

BubblesShowingCategories - Change the extension to .ods

There is an issue in the site, that only allow upload files with an graphic extension.

Edited 2013-11-03

I think the only way is have the data for different categories in different series.
BubblesShowingCategoriesInDifferentSeries

Thanks for answering, but as you say there is an issue there. u sure about the link?

Maybe you need right-click the link and select a download option or save the file, otherwise the browser tries to show the graphic file. After download the file change the extension from .jpg to .ods

Hi Mariosv,

Thanks for the help.
May I expand a bit. The idea with the categories is of course to display using different colors for each category. Since in your solution we’re dealing with a unique series, the only way is to do it “by hand” for both categories. In my real life it’s about several categories while the number of data for each category varies. In case you have an idea, this will save my life :slight_smile:
I tried also with scattered data, without success.
All my best and thanks again for the support

Moon

Hi Mariosv,

Thanks for the help.
May I expand a bit. The idea with the categories is of course to display using different colors for each category. Since in your solution we’re dealing with a unique series, the only way is to do it “by hand” for both categories. In my real life it’s about several categories while the number of data for each category varies. In case you have an idea, this will save my life :slight_smile:
I tried also with scattered data, without success.
All my best and thanks again for the support

Moon