it's useful to know but it doesn't do what I need. Let's say my the vertical axis has been showing 4K, changing it to M and it shows 0.004M, which is correct in terms what my data represents.
I suppose i can just have numbers against the axis (without K or M) and the user will be aware the figures are in thousands.
Copy and paste a screenshot of your chart, so I know what we're dealing with. Or make the chart using Superstore data and attach it here.
Marek, there really is a solution to your issue. Just need to know what chart you're building.
That is very helpful but the tooltips now show as thousands or millions and before formatting it showed the actual number.
I am attaching a screenshot of the axis prior to formatting the numbers. Note this is two bar charts, side by side. I don't know why one defaulted to k and the other to 1,000s.