We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Change color of graph: column chart [closed]

asked 2018-06-05 20:57:06 +0200

NexusDude gravatar image

updated 2021-05-15 20:36:54 +0200

Alex Kemp gravatar image

I have a simple bar chart--LO Calc calls it a column chart--that plots percentages per year. So X are years, and Y is a percentage for each year.

That's easy enough, but Calc insists on making the bars navy blue, and I can't have that. They can't be blue or red.

Is there a way to change them to green?

I saw "Range for Fill Color," but couldn't make it work.

Using LO Calc (or should I use the presentation tool?)

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 2021-05-15 20:37:01.611813

1 Answer

Sort by » oldest newest most voted

answered 2018-06-05 21:55:13 +0200

Ratslinger gravatar image


Please refer to my answer on this post -> Is it possible to create chart legends without use of color for b&w only publications?.

The only difference is that you would be selecting a different color as opposed to a pattern. Procedure is the same.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more


That's great. Thanks!

Too bad you can't select multiple bars & change them all at once. Oh, well.

Edit: Solved 2 new problems!

  1. If you're selecting individual bars & suddenly ALL the bars become selected (which happens often), then click outside the chart, then back in, then HOLD DOWN CTRL and triple-click on the bar you want to change.
  2. Save as ODS, not XLSX, if you want to save bar colors. Otherwise, they all revert to blue.
NexusDude gravatar imageNexusDude ( 2018-06-06 17:42:41 +0200 )edit

As a frequent user of charts myself, I recommend that everyone who uses charts also learn the ins and outs of Editing charts. The tools provided for customizing charts are very powerful and can be used to make any chart more illustrative and useful.

ve3oat gravatar imageve3oat ( 2018-06-06 22:17:38 +0200 )edit

Question Tools

1 follower


Asked: 2018-06-05 20:57:06 +0200

Seen: 3,048 times

Last updated: Jun 05 '18