Ask Your Question

How can I change the background of a data label in a Calc graph?

asked 2017-09-20 04:48:32 +0200

holy-harp gravatar image

I have a stacked bar chart with data labels. The patterns in the bars obscure the data labels. Can I give the data labels a background color that will blot out the bar pattern and allow the data to be visible?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-20 10:17:54 +0200

pierre-yves samyn gravatar image


The only workaround I know is to Right-ClickFormat Data Labels each problem labels to set a font color that stands out better on the background. You can also add a more or less thick border...

HTH - Regards

edit flag offensive delete link more

answered 2017-09-20 10:03:51 +0200

librebel gravatar image

Hello @holy-harp,

Unfortunately it is not possible to set the background color for a data label inside a Calc Graph.

For best readability you could set the "Area" type of the Bar to "Color" or "Gradient";

To improve readability when the "Area" type of the Bar is set to "Pattern" or "Hatch", you could set the "Font Effects" to "Outline" and choose a Bold font of sufficient size. HTH, lib

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-20 04:48:32 +0200

Seen: 167 times

Last updated: Sep 20 '17