Issue 64689 - Bubble chart
Summary: Bubble chart
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 46 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: ms_interoperability, rfe_eval_ok
: 71692 71714 (view as issue list)
Depends on:
Blocks: 72764
  Show dependency tree
Reported: 2006-04-24 11:42 UTC by
Modified: 2013-02-24 21:20 UTC (History)
12 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

5.d-Bubble_charts.xls (28.50 KB, application/
2006-04-24 11:43 UTC,
no flags Details
png sample (10.79 KB, image/png)
2006-04-25 11:11 UTC,
no flags Details
patch_090224 (20.71 KB, patch)
2009-02-25 01:29 UTC, weiz
no flags Details | Diff
example with small bubble sizes < 1 (11.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-31 12:50 UTC, IngridvdM
no flags Details
example for automatic number format detection (17.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-04-02 11:52 UTC, IngridvdM
no flags Details
Testcasespecification Bubblechart (14.43 KB, text/html)
2009-06-26 13:26 UTC, kla
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description 2006-04-24 11:42:37 UTC
cf : sample from Excel
Comment 1 2006-04-24 11:43:36 UTC
Created attachment 35964 [details]
Comment 2 IngridvdM 2006-04-24 12:24:25 UTC
accepted, set keywords, target and prio
Comment 3 pagalmes.lists 2006-04-24 22:09:14 UTC
Tony, could you also add a scr'eenshot of the bubble chart foc those not having
Excel ? Thanks !
Comment 4 2006-04-25 11:11:00 UTC
Created attachment 36010 [details]
png sample
Comment 5 2006-04-26 15:41:16 UTC
Hi Ingrid, this issue is UNCONFIRMED ?
Comment 6 IngridvdM 2006-05-16 14:48:37 UTC
Sorry, now it's accepted, as it should be :-)
Comment 7 kla 2006-11-20 10:05:56 UTC
*** Issue 71714 has been marked as a duplicate of this issue. ***
Comment 8 IngridvdM 2006-11-20 17:33:02 UTC
*** Issue 71692 has been marked as a duplicate of this issue. ***
Comment 9 hwieser 2007-03-15 16:14:15 UTC
This is the single reason I still have to resort to M$ Excel <sigh>
Comment 10 bob_nelson 2007-10-03 22:00:54 UTC
This has been outstanding for over a year, and is much more important to real
users than many of the eye candy changes to chart.  This is forcing my users,
and many others, to Excel.  Maybe it's time for a priority upgrade.
Comment 11 ooo 2007-10-04 09:32:43 UTC
I do agree totally!
And I wonder why my 2 votes for this issue constitute 50% of all votes for this
issue :-(
It really is much more important than shown by the few votes.
Comment 13 scagni 2007-12-24 12:22:40 UTC
I use OpenOffice - among other things - to teach and do research in statistics,
and try to spread its use whenever possible. In this field, the absence of
bubble charts is a significant and annoying problem.
The continuing lack of bubble charts is one of those incomprehensible gaps that
sometimes go on unnoticed for years. 
When I heard a revamping was in order for the charting module in 2.3, I wholly
believed bubble charting would be included. And I must agree that many of the
implemented improvements, while appreciable, were far less indispensable than a
good, flexible bubble chart option.
Almost everyday I have to answer - with difficulty and embarassment - some
students that ask about this problem.

Maybe it could be solved with an extension?
Or, as someone else suggested, it is simply time to give it a 2.4 target
Comment 14 IngridvdM 2008-06-04 11:41:46 UTC
change target to 3.x
Comment 15 barthox 2008-06-12 08:55:53 UTC
28 votes ... I guess we'll never see this feature ...
Comment 16 roadnottaken 2008-07-16 15:18:36 UTC
the lack of this feature is the only reason why i need to keep Excel
Comment 17 scagni 2008-07-17 12:42:50 UTC
How can we make something happen? A petition? A hunger strike? I am positively
desperate about this...... I have the depressing perspective of another course
year on basic data management and analysis with OO calc WITHOUT bubble
charting.... please no!
Comment 18 jolatt 2008-07-17 18:19:22 UTC
Comment 19 IngridvdM 2008-07-22 14:22:12 UTC
reset to new
Comment 20 IngridvdM 2008-11-11 09:27:42 UTC
@weiz, please implement the bubble chart.
For saving use the string 'bubble' for the attribute chart:class as defined in
You can take the scatter chart as example ( e.g. XML_SCATTER in xmloff ).
x and y values need to be saved within domain elements.
Comment 21 IngridvdM 2008-11-18 16:23:28 UTC
@weiz, a good start might be the chart type tab page. Introduce a new entry
there that represents the bubble chart and you will have something to test right
from the beginning on.
Look at class ChartTypeTabPage how the list m_aMainTypeList is filled.
Each main type is represented by a ChartTypeDialogController. Create a new class
BubbleChartDialogController. Use XYChartDialogController as example.
Comment 22 weiz 2009-02-25 01:29:22 UTC
Created attachment 60455 [details]
Comment 23 weiz 2009-02-25 01:35:41 UTC
@iha: The attached zip file contains the patch and new files for bubble chart.
Please let me know your suggestions. thanks.
Comment 24 scagni 2009-02-25 10:11:04 UTC
This is absolutely good news!!!! I am starting my OpenOffice basic statistics
course just next monday.... what a coincidence.
If the patch works I will be able to use in the forthcoming weeks.
I will post any emerging problem here in the near future.
Comment 25 scagni 2009-02-25 10:41:16 UTC
I beg your pardon....
I am a quite low-tech user... how do I install the patch???
I thought some instructions would be included... or it had the form of an
extension.... or an exe. But how do I make use of a .patch file?

Sorry for my deep incompetence. Any hint appreciated!
Comment 26 IngridvdM 2009-02-25 10:59:47 UTC
@scagni, this kind of patch is nothing that can be installed to the product but
it is something to modify the underlying code. So it is necessary to apply the
changes to the code and then compile it.
All, please be careful when picking single patches from within the middle of the
developing phase. If you use them there is a general risk that you create files
that cannot be parsed by the final version! In addition there were no people
from the Quality Assurance involved so far.

@weiz, thanks for the patch! I will start to a look at it soon. Currently I am
in the middle of correcting and hopefully finalizing another patch/modification
that broke quite a lot in the fist attempts.
Comment 27 scagni 2009-02-25 11:47:32 UTC
Thanks for the info. I will wait for a compiled version to be available then.
I hope this comes soon of course, but it will be welcome anyway whether after a
long or short time.
Sorry for the misunderstanding.
Comment 28 weiz 2009-03-05 01:36:46 UTC
the known problems in the patch_090224:
* the save and load feature has not been completed.
* If the bubble chart has only one series, then click "Insert series" item in
the "Data Table" dialog, a new series include the "X-Values" "Y-Values" and
"Size-Values" will be inserted, it caused by "lcl_getSharedSequences" in
"DataBrowserModel.cxx", the comment in the function "if we have only one series,
we don't want any shared sequences". 
* the patch only support 2D bubble chart.
Comment 29 scagni 2009-03-05 11:47:16 UTC
I am very happy things are moving briskly on this:
regarding the problems reported, I would be in favour of implementing a working
version as soon as possible, leaving optional enhancements for later upgrades.

This holds for example for the present lack of 3D functionality: AFAIK a good 2D
bubble chart is used - and is appropriate - 95% of the times. Start with it
then: 3D bubble objects can easily follow later on
Thanks anyway for all the effort!
Comment 30 IngridvdM 2009-03-13 11:47:04 UTC
@weiz, I'll take over for implementation of save and load. 
Comment 31 IngridvdM 2009-03-24 11:04:37 UTC
Save and load is implemented now.
Searching for further problems.

Set Daniel to CC for xls-im&-export.
The new role is "values-size".
The new service name is "".
Comment 32 daniel.rentz 2009-03-24 15:15:21 UTC
import from XLS, XLSX; export to XLS done
test files: -> Chart Types ->
Scatter/bubble charts -> BIFF8, XML2003, XML2007
Comment 33 IngridvdM 2009-03-24 17:50:33 UTC
Thanks Daniel! :-)
Now its also possible to set color etc. for a single bubble point.
Comment 34 IngridvdM 2009-03-31 12:45:57 UTC
The bubble sizes for small values (<1) were wrong as the maximum was calculated
wrongly (>=1). This is corrected now.
Comment 35 IngridvdM 2009-03-31 12:50:37 UTC
Created attachment 61314 [details]
example with small bubble sizes < 1
Comment 36 IngridvdM 2009-03-31 16:59:00 UTC
Also corrected the scaling of the bubble sizes. They now do scale with the
diagram size. The maximum bubble size is now 25% of the diagram size (min of
width and height).
Comment 37 IngridvdM 2009-04-02 11:49:17 UTC
Found and fixed further problems with the automatic detection of number formats
to be used for the y-axis, the data table and the data label. I'll attach a file
to illustrate.
First the case where data comes from a spreadsheet. If no number format is set
explicitly at the y axis the number format used for the labels at the y axis
should be that of the value sequence representing the y values (not the size
values). If no number format is set explicitly for the data series (or point)
the number format used for the data point labels should be that from the size
After copying such a chart from calc to impress the number format usage should
be as follows: Within the data table the x values should be displayed with the
number format set at the x-axis. The y-values should be displayed with the
number format set at the y axis and the size values should be displayed with the
number format set for the data labels at the series. During copy past the former
auto-detected number formats have to be set explicitely to the axis and data
series. This is aquivalent to how it works for xy charts within OOo 3.1.
Comment 38 IngridvdM 2009-04-02 11:52:56 UTC
Created attachment 61358 [details]
example for automatic number format detection
Comment 39 IngridvdM 2009-05-07 13:00:25 UTC
I updated several specifications:
A new entry 'Bubble' is inserted after 'XY (Scatter)' in the list of chart types.
For bubble charts a new entry 'Bubble Sizes' is offered per data series in the
'Data ranges' list.
For bubble charts the options 'Leave gap' and 'Assume zero' are available.
For bubble charts and scatter chart the option 'Show value as percentage is
disabled'. For bubble charts the same placement options are available as for
scatter charts.
Comment 40 IngridvdM 2009-05-07 13:04:35 UTC
Feedback from i-team was positive.
Created issue 101637 to update the documentation and issue 101635 to update the
automatic tests.
Comment 41 IngridvdM 2009-06-04 10:35:47 UTC
Finally added some spacing between data labels and bubbles.
Fixed in CWS bubblechart. Will resync to dev300m50 if that becomes available.
Comment 42 IngridvdM 2009-06-04 10:38:20 UTC
48 votes currently
Comment 43 IngridvdM 2009-06-04 17:07:01 UTC
The service description for the new type in the com::sun::star::chart-API was
also missing ->added.
Comment 44 IngridvdM 2009-06-15 09:06:40 UTC
Further options were not added to the bubble chart so far as they are not
defined with ODF yet, so it is not possible to save them with the document
currently. Those additional options can be added later after the file format is
I have written a feature request for example for the option to use the
size-values as diameter instead of area: issue 102779.
Please write additional issues if you want more options. Thanks for your input
and feedback.
Comment 45 IngridvdM 2009-06-17 09:04:01 UTC
50 votes.
->Thomas, please verify in CWS bubblechart.
Comment 46 kla 2009-06-26 13:26:27 UTC
Created attachment 63228 [details]
Testcasespecification Bubblechart
Comment 47 kla 2009-06-26 13:28:00 UTC
Long time waiting for and now -> verified in cws bubblechart
Comment 48 aoo-bugger 2009-06-26 15:36:48 UTC
Just a _minor_ flaw I would like to mention:
In the schematic preview thumbnails of the bubble chart in the Chart Wizard
(seen here are no
axes displayed, although there are axes.
E.g. the preview thumbnails of the pie charts have also no axes as there are
none, but column, bar, area, etc. does have axes in the picture...

(BTW: In case of Line and XY its also inconsistent as the axes are only
displayed in the left (first) preview, but not in the second previews on the right.)
Comment 49 IngridvdM 2009-06-26 15:49:03 UTC
@famo, the bubble icons were created consistently with the line and scatter
chart icons. If you think that it is worth the effort to change them all, please
write an issue to sts, as she designs the icons. Maybe such a change can be done
together with an overall redesign, as it sometimes happens. Thanks for your
input anyhow!
Comment 50 thorsten.ziehm 2009-07-20 14:53:26 UTC
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
If you want to know more about the handling of fixed/verified issues =>
Comment 51 thorsten.ziehm 2009-07-20 15:36:02 UTC
Sorry this issue was wrongly closed. This issue will be reopened automatically.
And will be set after that back to fixed/verified.
Comment 52 thorsten.ziehm 2009-07-20 15:40:20 UTC
Set to state 'fixed'.
Comment 53 thorsten.ziehm 2009-07-20 15:44:32 UTC
Set back to state 'verified/fixed'.

Again. Sorry for the mass of mails.
Comment 54 kla 2009-10-02 11:41:51 UTC
Seen ok in current master -> closed