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:
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.
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.
Status set to NEW. Summary amended for clarity.