Change color of graph: column chart

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?)


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 :heavy_check_mark: (upper left area of answer). It helps others to know there was an accepted answer.

That’s great. Thanks!

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

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.

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.