Ask Your Question
0

Several data series with different categories/labels in one chart [closed]

asked 2013-11-02 22:50:14 +0200

moon gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 20:36:25.171191

2 Answers

Sort by » oldest newest most voted
0

answered 2013-11-02 23:28:38 +0200

m.a.riosv gravatar image

updated 2013-11-03 23:34:52 +0200

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

edit flag offensive delete link more

Comments

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

moon gravatar imagemoon ( 2013-11-03 07:32:34 +0200 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2013-11-03 16:20:24 +0200 )edit

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 :-) I tried also with scattered data, without success. All my best and thanks again for the support

Moon

moon gravatar imagemoon ( 2013-11-03 19:18:20 +0200 )edit
0

answered 2013-11-03 21:33:46 +0200

moon gravatar image

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 :-) I tried also with scattered data, without success. All my best and thanks again for the support

Moon

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-11-02 22:50:14 +0200

Seen: 1,459 times

Last updated: Nov 03 '13