Bug 51670 - Add XYZ / Surface chart type
Summary: Add XYZ / Surface chart type
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 72045 81510 (view as bug list)
Depends on:
Blocks: Chart-Enhancements docx-aggressive-competitors
  Show dependency treegraph
Reported: 2012-07-02 14:36 UTC by Valek Filippov
Modified: 2021-04-01 12:07 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:

file with a problem (39.00 KB, application/vnd.ms-excel)
2012-07-02 14:36 UTC, Valek Filippov
Screenshot from XL2003 (38.11 KB, image/png)
2012-07-02 14:37 UTC, Valek Filippov
This is Excel 4.0 from 1992 can do 3D plot (139.77 KB, image/jpeg)
2018-06-13 18:07 UTC, Joachim Otahal
LibreOffice XYZ Chart simulation (202.36 KB, application/octet-stream)
2021-04-01 12:07 UTC, Joachim Otahal

Note You need to log in before you can comment on or make changes to this bug.
Description Valek Filippov 2012-07-02 14:36:24 UTC
Created attachment 63731 [details]
file with a problem

LO Calc 3.6b2 shows multiple 3d bars instead of surface on the chart.
Comment 1 Valek Filippov 2012-07-02 14:37:10 UTC
Created attachment 63732 [details]
Screenshot from XL2003

How it should look like.
Comment 2 Rainer Bielefeld Retired 2012-07-02 23:42:34 UTC
[Reproducible] with "LibreOffice  German UI/Locale [Build-ID: 24b32b4-b87ec2e-85c8e98-87a4e20-9a1b8c1] on German WIN7 Home Premium (64bit), same with LibO 3.3.3 and OOo 3.1.1, so inherited from OOo.

Looks more or less ok with Gnumeric, fine with MS EXCEL Viewer. 

Another problem with a document created with SoftMaker software (?)

I doubt that many users are affected, so not MAB

@Valek Filippov:
Please contribute info concerning your OS!

@Kohei, @Markus:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept
this Bug
Comment 3 Robert Cabane 2012-11-24 22:14:19 UTC
See :
(no solution is given there)
In order to address such chart types, we need a 3 surface renderer (I mean, something like z=F(x,y)).
One could (internally) delegate the plot to gnuplot.
Comment 4 Robert Cabane 2012-11-24 22:15:52 UTC
I'm using LO 3.6.2 under Linux, same effect as noted by the reporter.
Comment 5 Joel Madero 2013-12-22 17:18:04 UTC
*** Bug 72045 has been marked as a duplicate of this bug. ***
Comment 6 Joel Madero 2013-12-22 17:20:08 UTC
I am changing this to an enhancement request - we just don't have this particular type of charting ability, adding it is an additional feature and therefore an enhancement
Comment 7 Gerry 2014-05-20 09:40:27 UTC
There is a basic workaround available for surface charts:

Of course, it is not a replacement for real Surface charts, but it might be sufficient for a few use cases.
Comment 8 Owen Genat (retired) 2014-08-29 02:05:36 UTC
"Type" added to summary so that all enhancement requests relating to chart types are readily findable.
Comment 9 Joachim Otahal 2018-02-11 19:50:52 UTC
LO 6.0, and still no surface plot/chart.
Comment 10 Buovjaga 2018-06-13 16:54:20 UTC
*** Bug 81510 has been marked as a duplicate of this bug. ***
Comment 11 Joachim Otahal 2018-06-13 18:07:16 UTC
Created attachment 142713 [details]
This is Excel 4.0 from 1992 can do 3D plot
Comment 12 Xisco Faulí 2019-11-29 13:28:53 UTC
Changing priority back to 'medium' since the number of duplicates is lower than 5
Comment 13 birger 2020-03-22 22:09:25 UTC
Is it possible to contribute to bumping up the priority by commenting here or do I have to create a duplicate request? (Looking at the last comment here)

This is *the* feature I have been missing for many years. 3D surface plots are the best way I have found to visualize stuff like RAID controller performance. It would be very nice to have it built in instead of having to reformat data for gnuplot and run an external program.
Comment 14 Joachim Otahal 2020-03-22 22:31:41 UTC
(In reply to birger from comment #13)
> Is it possible to contribute to bumping up the priority by commenting here
> or do I have to create a duplicate request? (Looking at the last comment
> here)

Nope and Nope. Neither here or the feature request page. This request is simply turned down every time I contact them. Including Facebook and others.
The actual "usable" answer I got way: Pay one of the developers, and the MAYBE the feature will be programmed.
I would not have a problem shelling out three digit Euros for KNOWING this feature will be included within three month, and it's usability improved in later version. But in its current state LO does IMHO not have the right priority list. Making new icons is more important than a 28 year old excel feature - why?
Luckily there are other free office products, though not open source, which can do it when needed. Softmaker Freeofice is one example.
Comment 15 Joachim Otahal 2021-04-01 12:07:14 UTC
Created attachment 170892 [details]
LibreOffice XYZ Chart simulation

This is the closest to a XYZ chart you can get with LO