Bar chart issue

[alec1982]

Hi Guys,

I have couple of simple bar charts. they both set to be horizontal charts. as I know if the value is positive it will show to the right and then if it is negative it will show to the left. such as what I am showing in the attached image(the left chart).

Not sure why the right chart is showing negative value to the right side on some dimenssions!

Hope someone can explain that to me so i can have consistent charts.

Thxs,

Alec

[Anonymous]

Hi,

Can u share a sample file of it??

Thanks

[Anonymous]

Strange. A few troubleshooting suggestions:

Turn your bar chart into a straight table to make sure it is a negative value.

Tick the Force zero and set the Min to '0' on the Axis sheet and see if this value still appears.

Check the Number format. Is it 'expression default' and are you setting the Num() formatting in the expression ?

Jonathan

[alec1982]

It is strange for sure!

The nr is negative when i use it somewhere else but on the chart is showing as negative nr for some reason. in fact if a filter on that dimension The nr move to the left.!!

[Anonymous]

Perhaps recreate the chart or even the document to see if there is some sort of corruption. Else try on a different version.

Jonathan