Bug 82528 - CHART: Provide option to set relative scaling of size dimension (of largest bubble) in Bubble Chart
Summary: CHART: Provide option to set relative scaling of size dimension (of largest b...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
 
Reported: 2014-08-12 22:21 UTC by Doug
Modified: 2023-12-07 00:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
dialog box in step 5, no option to change bubble size (20.77 KB, image/png)
2014-08-12 22:21 UTC, Doug
Details
ODS with 3 charts showing relative bubble sizing in LOv4322. (47.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-10-11 11:19 UTC, Owen Genat (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Doug 2014-08-12 22:21:24 UTC
Created attachment 104528 [details]
dialog box in step 5, no option to change bubble size

1.  Create bubble chart in LO Calc
2.  Link to data to change sizes of bubbles, succeed in creating data series.
3.  Bubbles all are too large, would like to make smaller.
4.  Right mouse click on bubbles to select "Format Data Series"
5.  No options to modify sizes of bubbles (so that all bubbles, while varying in size, nonetheless are smaller).  See screen shot of dialog box.

EXPECTED RESULT:  option to make area or diameter of bubbles smaller.  Might also work as a z-axis, but that is not available either.

ACTUAL RESULT:  no built-in option to change scale/size of bubbles in chart.

Bug also noted on this message board:
http://listarchives.libreoffice.org/global/users/msg17291.html

Workaround noted to change value of one of datapoints, to change data scale, but since it involves changing underlying data is it not optimal approach.

Classified as enhancement.
Comment 1 Owen Genat (retired) 2014-10-11 11:19:21 UTC
Created attachment 107712 [details]
ODS with 3 charts showing relative bubble sizing in LOv4322.

(In reply to Doug from comment #0)
> 2.  Link to data to change sizes of bubbles, succeed in creating data series.
> 3.  Bubbles all are too large, would like to make smaller.

I can understand the request. To clarify, this is what ODF v1.2, Part 1, §19.5.1 states:

> chart:bubble – Circles(bubbles) with different sizes are displayed in a
> Cartesian coordinate system with horizontal x-axis and vertical y-axis. 
> The values given by a chart:values-cell-range-address attribute on a
> <chart:series> element are interpreted as relative bubble area.

... thus the size of the largest bubble is a fixed measure, to which all other bubbles are relative in size. Refer attached example. 

> Workaround noted to change value of one of datapoints, to change data scale,
> but since it involves changing underlying data is it not optimal approach.

While it is possible to include sizing in the data (as indicated), this particular chart type is not handled well by the wizard, making data manipulation even more tedious. A solution may be to set the scale (relative size) for the largest bubble via an option and calculate all bubble sizes based on this additional value, somewhat like a zoom factor.
Comment 2 Owen Genat (retired) 2014-10-11 11:23:14 UTC
Status set to NEW. Summary amended for clarity.