Abbreviations in Axis tick marks

[jordanParticipant]

I have to present graphs to non-technical people. Is it possible to use “K” or “M” for 1000’s or 1,000,000’s in the tick mark labels? In my case, I am setting the Y tick marks to currency, but it does not really give many options except with regard to international formats. I think it would be really great if currency symbols ($) could be selected like in the data table, and I would really like to add some abbreviations if possible. If this is not possible, any good work arounds? Thanks.

 

[kirktParticipant]

You can try converting your currency to whatever range you want with an expression (the “f(x)” command) to scale it – to thousands for example so that you can use “K” as your abbreviation.  Then use currency as your Y tick mark and use theY format prefix and suffix modifiers.  Specify the currency symbol to whatever your data are using – set the prefix to “€” for example – and the scaling modifier by setting the suffix to “K” for thousand.  You can also experiment with a logarithmic scale versus a linear scale for the Y axis, depending on the range of your currency data.  Sorta brute force, but should work.

kirk

• This reply was modified 2 years, 2 months ago by kirkt.

[jordanParticipant]

Kirk,

Yep, you are right…that approach works perfectly. Thanks!

 

Jordan

[kirktParticipant]

Cool – glad it worked!

kirk

[Author]

Posts