Ask Your Question

Surface charts in Calc [closed]

asked 2014-04-14 17:20:14 +0200

lactea gravatar image

updated 2020-07-09 11:21:05 +0200

Alex Kemp gravatar image

I understand that there is no direct way of producing surface charts in LO Calc. There are surface chart workaround.ods like this. The existing functions for changing perspective, apperance and illumination are really neat. However, this is not the real thing as features like colorization by value range/elevation are missing.

Are there any other workarounds that I am not aware of yet?

Or is it better to use other software like gnuplot?

Is there enough interest to raise a feature request?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 20:14:19.269960

1 Answer

Sort by » oldest newest most voted

answered 2014-04-16 09:29:20 +0200

oweng gravatar image

updated 2014-04-16 09:33:57 +0200

Within the ODF v1.2 specification, 19.15.1, there is a chart:class of chart:surface however the definition appears (to me) to be ... tedious, or at least fairly entangled with cell ranges and the 3D setting. The related enhancement to get this implemented is fdo#51670, which contains a good basic example of a surface chart created in Excel that renders in Calc as a set of discreet columns (rather than a homogeneous surface). It is probably also worth noting the various OASIS issues that relate to "surface+chart".

edit flag offensive delete link more


Thank you @oweng. Looks like I have to move to gnuplot for this.

lactea gravatar imagelactea ( 2014-04-17 17:29:04 +0200 )edit

Quick note: after more than 3 years, I am happily using R and the plot3D package. Works like a charm.

lactea gravatar imagelactea ( 2017-11-17 08:58:21 +0200 )edit

Question Tools

1 follower


Asked: 2014-04-14 17:20:14 +0200

Seen: 10,769 times

Last updated: Apr 16 '14