Ubuntu: Fill the area below/above an x-y curve in Calc


I want to draw a plot with the points:

y >= f(x)  

where f(x) is some function I define.

Using an x-y plot, I can draw only the function:

y = f(x)  

Using an area plot, I can draw an area of a single column (i.e. not y as a function of x). Is there any way I can fill the area above the x-y curve?

EDIT: When the x values are linear (i.e. 0, 1, 2, ...) then it is easy to fill the area below the curve by using an area plot with the y series only, like here (right):

enter image description here


LibreOffice Calc doesn't allow for editing the area above / below a X/Y data series (line). So i see the following options:

  • try to use a area chart type;

  • export the chart as graphic, e.g. SVG (this is a 4.0+ feature) and edit the resulting picture;

  • use Gnumeric to create the chart - Gnumeric allows for modifying the area below a X/Y plot.


I don't know whether it is possible in Libreoffice Calc, so I advise you to use another program for doing the plot. If you don't want to learn the syntax of a program with serious plotting capabilities, like R or gnuplot, you can use geogebra.

sudo apt-get install geogebra  

Then just launch geogebra, and write in the Input field at the bottom of the window, e.g:


and your graph is plotted. You can right-click on the object to change its properties (color, line width, etc.). After you are done, just Move the graphics plan to the position you want the graph to be displayed and use the Export option from the File menu. E.g export into .png then insert the image into Calc.

geogebra is a very handy tool for simple plotting, it is very easy to make animated plots in it also.

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »