Bar Chart (upside down)

[#1]

Hi. I want to display a bar chart so the horizontal axis is on top and the bars proceed down from there. I have temporarily achieved something close to this by making my expressions negative.

But this leaves me with two problems.

     1) The axis (and labels) are still on the bottom of the chart.

     2) The numbers on the axis display as negative.

So I have two questions:

     1) Is there a way to manipulate this to make the labels appear on top of the chart and make the values appear positive despite being negaitve?

     2) Did I miss some more simple formatting that would enable me to do this without having to find a workaround?

Thanks so much for any help.

[MarcoWedel]

Hi,

maybe this helps:

regards

Marco

[#3]

Thanks, Marco. That's pretty much what I'm going for. But how did you make that happen?

[jduenyas]

Click in the chart and then Ctrl+Shift and observe all the red boxes.

Then go to the chart's properties and see in Presentation the values in Reference Lines and Text in Chart.

Also in the Axes tab see the Hide Axis check and the values for the Static Min and Static max.

That will start you going

[MarcoWedel · Accepted solution]

Hi,

I used this expression

=Dual(Fact,-Fact)

to format negative expression values as positive numbers, hid the expression axis and added reference lines and texts in chart instead.

Maybe not the most dynamic solution, but hopefully can be of any use nevertheless.

Regards

Marco

[#6]

I wound up doing something very similar to this. Thank you.

[#7]

Awesome. That works great and is basically exactly what I was going for. Thanks a lot.

[MarcoWedel]

You're welcome

regards

Marco