How to render bubble graph in libreoffice calc
up vote
0
down vote
favorite
I'm trying to render a really simple graph using bubbles, on the first column I have the name of the bubble, then on the right cell X and then Y coordinates, the fourth column has the size value.
I have selected the area and specified it has data in lines, values of X and Y ranges between 0 and 255 while values of size ranges from 1 to 100.
I'm not able to show a correct graph, in fact when I switch to data series, it doesnt correctly assign X,Y and size to the relative cell of each entry, rather it assumes Y and size as ranges rather than a single cell, and just ignore my X giving no value at all.
What am I doing wrong?
libreoffice libreoffice-calc
asked Nov 17 at 14:24
Ritardi.Net
548
add a comment |
up vote
0
down vote
favorite
I'm trying to render a really simple graph using bubbles, on the first column I have the name of the bubble, then on the right cell X and then Y coordinates, the fourth column has the size value.
I have selected the area and specified it has data in lines, values of X and Y ranges between 0 and 255 while values of size ranges from 1 to 100.
I'm not able to show a correct graph, in fact when I switch to data series, it doesnt correctly assign X,Y and size to the relative cell of each entry, rather it assumes Y and size as ranges rather than a single cell, and just ignore my X giving no value at all.
What am I doing wrong?
libreoffice libreoffice-calc
asked Nov 17 at 14:24
Ritardi.Net
548
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm trying to render a really simple graph using bubbles, on the first column I have the name of the bubble, then on the right cell X and then Y coordinates, the fourth column has the size value.
I have selected the area and specified it has data in lines, values of X and Y ranges between 0 and 255 while values of size ranges from 1 to 100.
I'm not able to show a correct graph, in fact when I switch to data series, it doesnt correctly assign X,Y and size to the relative cell of each entry, rather it assumes Y and size as ranges rather than a single cell, and just ignore my X giving no value at all.
What am I doing wrong?
libreoffice libreoffice-calc
asked Nov 17 at 14:24
Ritardi.Net
548
I'm trying to render a really simple graph using bubbles, on the first column I have the name of the bubble, then on the right cell X and then Y coordinates, the fourth column has the size value.
I have selected the area and specified it has data in lines, values of X and Y ranges between 0 and 255 while values of size ranges from 1 to 100.
I'm not able to show a correct graph, in fact when I switch to data series, it doesnt correctly assign X,Y and size to the relative cell of each entry, rather it assumes Y and size as ranges rather than a single cell, and just ignore my X giving no value at all.
What am I doing wrong?
libreoffice libreoffice-calc
libreoffice libreoffice-calc
asked Nov 17 at 14:24
Ritardi.Net
548
asked Nov 17 at 14:24
Ritardi.Net
548
edited Nov 17 at 14:29
asked Nov 17 at 14:24
Ritardi.Net
548
asked Nov 17 at 14:24
Ritardi.Net
548
asked Nov 17 at 14:24
Ritardi.Net
548
548
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53352110%2fhow-to-render-bubble-graph-in-libreoffice-calc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
