Is it possible to create an arithmatic scale ?

[#1]

Dear All

I have created a scatter chart with x axis as expiry date & y axis as contract spend.

There are few contract which has some 100 Million USD + spend while many in the 0.1 to 10 Million USD.

Because of some few high spend contracts, the graph become skewed.

Is it possible to show arithmatic scale, dividing the y axis into three part

0 to 10 Mio USD

10 to 100 Mio USD

100 + USD

Thanks in advance!

Best Regards

Rahul Kale

[#2 · Accepted solution]

Did you try the  log10 function

So your expression should be  log10( sum(Y))

JJ

[#3]

Thanks JJ