Ask Your Question

How to color scatter plot points from color-formatted data. [closed]

asked 2014-07-18 22:57:32 +0100

aurelius resartus gravatar image

updated 2015-08-31 22:47:33 +0100

Alex Kemp gravatar image

I'm on version of Calc. I have a single column of data which I colored based on a non-data criteria. I tried a second column with color names but had no success that way. Thanks in advance.

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-29 23:35:40.127738

1 Answer

Sort by » oldest newest most voted

answered 2014-07-19 16:48:20 +0100

m.a.riosv gravatar image

Seems It is a new feature in the next release 4.3,

Release Notes 4.3

where is linked a detailed explanation in Markus blog,


edit flag offensive delete link more


Excellent! Great feature. I will delete my answer. It is not quite using the colour format of the data, but it does offer a mechanism for colouring individual data points. It uses separate cell references that must contain a formula to determine the colour i.e., like conditional formatting. Support for both area and border will eventually be available according to what I can see in the v4.4 alpha release.

oweng gravatar imageoweng ( 2014-07-20 01:13:01 +0100 )edit

Question Tools

1 follower


Asked: 2014-07-18 22:57:32 +0100

Seen: 1,254 times

Last updated: Jul 19 '14