Ask Your Question

How to change diagram colours in Calc?

asked 2015-09-14 06:58:20 +0200

updated 2015-09-14 10:02:01 +0200

Alex Kemp gravatar image

Hi, I'm working on LibreOffice Is there any option to manipulate the colours of diagrams in LibreOffice Calc? I always get colourful diagrams - nice, but I need them in grayscale due to printing limitations.

Cheers, Jürgen

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-09-14 07:27:02 +0200

Double click on the chart > right click on first series > Format Data Series. In the tab Area of the dialog window, choose the Fill color among gray 1 …. gray 10.

If this helps then please tick the answer (✔)

image description

edit flag offensive delete link more


I am working with libreoffice 5.2.2 and this option is no longer valid. Well it is, but no matter which colours you choose, calc will use default colour palette. Is there any workaround in order not to change all diagrams' palettes?

Carlos Cámara gravatar imageCarlos Cámara ( 2016-10-13 20:17:49 +0200 )edit

I checked this in LibreOffice Here it works in a slightly different way - but works: after double-clicking the chart (or the the line of a graph), you can open the dialogue window "Data Series" with a right-click of your mouse. It pops up with two register cards. Choose "Line" where you can alter the style and the colour.

jueshire gravatar imagejueshire ( 2017-02-06 14:19:29 +0200 )edit

answered 2015-10-01 09:26:17 +0200

pierre-yves samyn gravatar image


My advice would be to keep colored diagrams and use the printer properties to print in grayscale. To do this, File Print, General tab and click the Properties button. All printers provide this option (including programs like PdfCreator).

Otherwise, it is possible to change the default color sets (for new charts): Tools Options Charts Default Colors


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-09-14 06:58:20 +0200

Seen: 6,063 times

Last updated: Oct 01 '15