Ask Your Question

how set colors for color and fill in charts

asked 2019-05-26 19:22:57 +0200

catbill gravatar image

In the Chart Wizard, we can enter ranges for color and fill for each data series. The problem is that I don't know what to put in the cells.

Presumably the cells could contain numeric codes for colors. That way, each data point could have its own color. But what codes are used? How do I find/derive them?

Also, I have read about property mapping and it sounds like it could be used. In fact, it looks like there used to be a button for property mapping. However, there is such button now. If I want to use property mapping, what do I do? Can anyone share examples?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-05-27 19:39:16 +0200

ve3oat gravatar image

Once a chart has been created, many aspects of it can be editted by Formatting. Double click on a chart to put it into Edit mode, then left-click on an axis, or a data point, or a title, etc. to select it. Then right-click on that thing. (Wait, it takes a moment ... ) then a dialog box appears, with an entry for Format Axis, Format Data Series, Format Title, etc. Choose that. Here is a resulting Format box for formatting the area of the bars in a bar chart.

image description

Formatting the border is reached by right-clicking on a vacant area of the chart and choosing Format Chart Area, then choose either the Borders or Area tab.

Formatting of charts is powerful and there are many possible options (though not everything you might think of is always possible). Experimentation is recommended.

edit flag offensive delete link more



Good information. However, I specifically want to know how to specify the colors using the Chart Wizard.

catbill gravatar imagecatbill ( 2019-05-27 19:57:20 +0200 )edit

Sorry, I am not able to help with that.

ve3oat gravatar imageve3oat ( 2019-05-27 23:26:35 +0200 )edit

answered 2019-05-27 08:31:02 +0200

ebot gravatar image

updated 2019-05-27 17:39:34 +0200

What do you mean? Is it this dialog box, do you mean?

image description

Please, which OS and LO-Version do you use?

You can take a screenshot and upload it here. To upload edit your question.

You can see how it works in the guidline.

Please, don't use an answer!

EDIT 20190527-17.40

image description

edit flag offensive delete link more


I am asking about the data ranges for border color and fill color that are in the screenshot you posted.

I am not sure how to make my question clearer. If I want to set the colors for border color and fill color by specifying ranges, what data needs to be in the cells to indicate colors?

I am using Windows 10 and LO versions and However, I don't know how the versions are relevant for understanding how this is supposed to work.

catbill gravatar imagecatbill ( 2019-05-27 16:15:02 +0200 )edit

I checked, in earlier versions there was no selection "Border" and "Fill". See documentation. I have also specified different areas from the table, it has shown no effect. Sorry, I can not tell you more about that. See my edited answer.

ebot gravatar imageebot ( 2019-05-27 17:03:48 +0200 )edit

Thank you for checking. I just re-read my previous comment and realize that it may sound a bit snippy. I did not intend that and appreciate that you are a helpful contributor. I will try to investigate elsewhere and report back here when I find an answer.

catbill gravatar imagecatbill ( 2019-05-27 18:42:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-26 19:22:57 +0200

Seen: 36 times

Last updated: May 27