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: 4.3.0.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-12 22:21 UTC by Doug
Modified: 2014-10-11 11:23 UTC (History)
0 users

See Also:
i915 platform:
i915 features:

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 		Details
View All

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 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 2014-10-11 11:23:14 UTC 
Status set to NEW. Summary amended for clarity.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.