Negative values in logarithmic axis

[former_member589159]

i need to view a column chart that her axis is logarithmic with negative values like this:

but when I set the axis to be logarithmic i get:

and on liner, the differences are just too big and you can't really see anything

I have created a new variable with this formula

= If([OTC]>0) Then Log10([OTC]) Else -Log10(-[OTC])

and I get close to what I need

but the values are wrong, I need it to be what is written in blue

what can be done?

[former_member589159]

someone have a soultion?

[amitrathi239]

have you tried with setting up the maximum and minimum scaling values?