More bar chart questions

[#1]

Pls see attached.

Bars were too far apart so I clicked the Continuous checkbox which moved the bars closer together, but changed the dates from a normal format to Julian!

Also, in the Color tab, setting Value > 0 for green works well, but Value < 0 for red, doesn't work, all the bar remain green.  Why?

Thx,

Brooks

[Gysbert_Wassenaar]

1. On the number tab you can change the formatting of the continuous axis. Change it to the date format you want.

2. No, idea. Try clicking on the + in front of the expression, choose Background Color and enter in the Definition field an expression to calculate the color. Something like if( sum(Amount) > 0, green(), red() ). Replace sum(Amount) with the expression that calculates the values of the bars.

[#3]

Thanks Gysbert, you fixed #1.  I don't see just a Background color.  There is Background Color under Frame Background but that turns the background, not the bars, a different color.

[Gysbert_Wassenaar · Accepted solution]

[#5]

Super, that did it.  Thanks!