Ask Your Question

How to display axis labels (for categorized data) in bubble chart ? [closed]

asked 2012-12-12 11:26:33 +0100

Antonello Lobianco gravatar image

updated 2013-02-01 09:34:13 +0100

qubit gravatar image

I need to obtain a bubble chart of categorized data, similar to this one:

My data looks like:

forType_label   reg_label   forType_n   reg_n   area
broadleaves     AL      1       1   20
broadleaves     AU      1       2   15
broadleaves     PA      1       3   30
coniferous      AL      2       1   7
coniferous      AU      2       2   6
coniferous      PA      2       3   9

I managed to get the bubble chart and, setting manually the chart axis options, to shown only integer numbers, but how can I shown labels (forType labels and reg labels)?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:01:39.979512


This question should not be closed, at least not with the label "the question is answered, right answer was accepted". As indicated in the comment to the answer, it doesn't solve the problem. The true is that it is not possible to do what the question asks, and a bug as been filled in the libreoffice bug tracker.

Antonello Lobianco gravatar imageAntonello Lobianco ( 2016-11-15 11:52:04 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-12-13 00:11:12 +0100

m.a.riosv gravatar image

While editing the chart. Menu/Insert/Data Labels.
or right-click on a bubble, insert Data Labels.
And mark show value as number

edit flag offensive delete link more



Thank you mariosv. This make the value appearing on the bubbles, but it doesn't solve my main problem that is how to display labels on the axis? E.g. I don't want "1" and "2", I want display "Broad-leaves" and "Coniferous" on the horizontal axis and "AL","AU" and "PA" on the vertical axis.

Antonello Lobianco gravatar imageAntonello Lobianco ( 2012-12-13 15:10:07 +0100 )edit

Question Tools


Asked: 2012-12-12 11:26:33 +0100

Seen: 2,745 times

Last updated: Dec 13 '12