Skip to Content

Negative values in logarithmic axis

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?

capture.png (16.4 kB)
capture.png (19.1 kB)
capture.png (20.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Oct 22, 2018 at 12:22 PM

    someone have a soultion?

    Add comment
    10|10000 characters needed characters exceeded