1 month, 3 weeks ago 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.1 month, 3 weeks ago 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.
1 month, 2 weeks ago jordanParticipant
- This reply was modified 1 month, 3 weeks ago by kirkt.
Yep, you are right…that approach works perfectly. Thanks!
Jordan1 month, 2 weeks ago kirktParticipant
Cool – glad it worked!
You must be logged in to reply to this topic.