[Solved] Different bar colors for positive/negative numbers

[Lt2210]

I have a bar chart to show the monthly profit/loss of an item. I would like the bar colors to be blue for positive results and red for negative results. Is there a way to format the bars for this?

[Lupp]

You may have a look into the attached example.

aoo112472_ColumnChartColors.ods

(18.15 KiB) Downloaded 85 times

[Lt2210]

Re: Lupp Thank you! Your chart was EXACTLY what I needed!

[cwolan]

@Lupp

There is a note in your .ods file: I don't know a way to center the columns for both series with respect to the grid/labels.
If I get it right, one could in this particular case:

• set Overlap to 100% (the Data Series dialog, Options tab)
  or
• use the Stacked subtype of the Column chart type

⠀

[Lupp]

@Lupp
There is a note in your .ods file: I don't know a way to center the columns for both series with respect to the grid/labels. ...

Thanks. Overlap 100% did the trick. I never had noticed the Overlap setting.