[Chart] [Begginer] Colors in instances

asked 2016-02-12 03:42:18 +0100

Jaba gravatar image

Hi, guys. Here is the example:

OBS: the original file has more than 15.000 cells.

Column A | Column B

0 | Car

1 | Bike

2 | Bike

Where is "Car" I have to put a red color in my chart and where is "Bike" i have to put a yellow color. The first column is like the horizontal axis representing the ID. The second one is like the classification. I don`t know how to identify the words "Car" and "Bike" and associate a color with these instances in LibreOffice. Here is an image link with an example of the output that I want:

http://i.imgur.com/pqqm3Bo.jpg

Thank you!

edit retag flag offensive close merge delete