Issue 64689

Created attachment 35964 [details]
5.d-Bubble_charts.xls

accepted, set keywords, target and prio

Tony, could you also add a scr'eenshot of the bubble chart foc those not having
Excel ? Thanks !

Created attachment 36010 [details]
png sample

Hi Ingrid, this issue is UNCONFIRMED ?

Sorry, now it's accepted, as it should be :-)

*** Issue 71714 has been marked as a duplicate of this issue. ***

*** Issue 71692 has been marked as a duplicate of this issue. ***

This is the single reason I still have to resort to M$ Excel <sigh>

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.

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.
Gisbert

Any news on this ? 

more example of bubble charts
http://www.excel-erate.biz/excel/chart_bubble.htm
http://astuces.jeanviet.info/bureautique/excel-2007-realiser-un-graphique-a-bulles-en-toute-simplicite.htm

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
milestone.....

change target to 3.x

28 votes ... I guess we'll never see this feature ...

the lack of this feature is the only reason why i need to keep Excel
installed.....  

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!

Voted.

reset to new

@weiz, please implement the bubble chart.
For saving use the string 'bubble' for the attribute chart:class as defined in
ODF1.2.
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.

@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.

Created attachment 60455 [details]
patch_090224

@iha: The attached zip file contains the patch and new files for bubble chart.
Please let me know your suggestions. thanks.

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.
Thanks

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!

@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 OpenOffice.org 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.

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.

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.

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!

@weiz, I'll take over for implementation of save and load. 

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 "com.sun.star.chart2.BubbleChartType".

import from XLS, XLSX; export to XLS done
test files: http://sc.openoffice.org/testdocs/index.html -> Chart Types ->
Scatter/bubble charts -> BIFF8, XML2003, XML2007

Thanks Daniel! :-)
Now its also possible to set color etc. for a single bubble point.

The bubble sizes for small values (<1) were wrong as the maximum was calculated
wrongly (>=1). This is corrected now.

Created attachment 61314 [details]
example with small bubble sizes < 1

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).

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
sequence.
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.

Created attachment 61358 [details]
example for automatic number format detection

I updated several specifications:
- http://specs.openoffice.org/chart/wizards/ChartWizard.odt
A new entry 'Bubble' is inserted after 'XY (Scatter)' in the list of chart types.
- http://specs.openoffice.org/chart/dataselection/FlexibleSourceRangeSelection.odt
For bubble charts a new entry 'Bubble Sizes' is offered per data series in the
'Data ranges' list.
- http://specs.openoffice.org/chart/MissingValues.odt
For bubble charts the options 'Leave gap' and 'Assume zero' are available.
- http://specs.openoffice.org/chart/ChartDataLabels.odt
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.

Feedback from i-team was positive.
Created issue 101637 to update the documentation and issue 101635 to update the
automatic tests.

Finally added some spacing between data labels and bubbles.
Fixed in CWS bubblechart. Will resync to dev300m50 if that becomes available.

48 votes currently

The service description for the new type in the com::sun::star::chart-API was
also missing ->added.

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
extended.
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.

50 votes.
->Thomas, please verify in CWS bubblechart.

Created attachment 63228 [details]
Testcasespecification Bubblechart

Long time waiting for and now -> verified in cws bubblechart

Just a _minor_ flaw I would like to mention:
In the schematic preview thumbnails of the bubble chart in the Chart Wizard
(seen here http://specs.openoffice.org/chart/wizards/ChartWizard.odt) 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.)

@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!

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 =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues

Sorry this issue was wrongly closed. This issue will be reopened automatically.
And will be set after that back to fixed/verified.

Set to state 'fixed'.

Set back to state 'verified/fixed'.

Again. Sorry for the mass of mails.

Seen ok in current master -> closed