Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Super, that did it. Thanks!