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.
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.
This reply was modified 2 years, 2 months ago by kirkt.