Ask Your Question
0

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

3 Answers

Sort by » oldest newest most voted
0

answered 2019-09-22 18:35:21 +0200

ChameleonScales gravatar image

updated 2019-09-22 18:55:51 +0200

The cells have to contain hexadecimal color values converted to decimal values (e.g. 4BFFA9 becomes 4980649).

You can make that conversion in Calc with the formula HEX2DEC($cell) (don't forget to remove the "#" of the hex values if you have one)

You have to fill in as many cells with color values that you want to colorize chart elements in the specified category.

Each cell selected in the "Range for fill color" attribute will affect its corresponding chart element (column or row) within the category.

For example in this case, even though I created a color for each row of my chart values, since I only selected the first 4, the remaining 3 stayed at the default color (red):

image description

The Column A (blue bars) stayed entirely unaffected since I didn't set a range for that category in the wizard.

edit flag offensive delete link more

Comments

Darn. Was hoping Data Series Property Mapping would enable defining line properties for XY Scatter plots in Calc 6.4.

arg gravatar imagearg ( 2020-02-26 20:24:52 +0200 )edit
0

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

Comments

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 6.2.0.2 and 6.1.0.3. 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
0

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

Comments

1

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 820 times

Last updated: Sep 22 '19