Please help me in replacing the 1000 with the letter 'K' on the charts axis. Please tell me the pattern to be used. Thanks in advance
go to the Number tab of the chart property, then type K in place of "Thousend" textbox your axes will be maked as K in place of 1000.
thanks for your quick reply. I did as you said but it was helpful for only some extent. It is showing a 'K' symbol on the top of the axes.
But i want to see the label values as 20k,30k40k.. etc....Can you please help me.??
Thanks for the reply, Let me be more clear on this,
If the values on the axis are
30000 and so on
I want those values to change into...
30k and so on........
Please help me in this....
Is it always going to be in thousands - k. what if your values turn out to be in M's or B's as your data grows? You can divide the metric by a 1000 as someone suggested above and append a K to that....and so on for M's & B's. Can be done in the script or UI.
Another option is to add Text in Chart and place it appropriately along the axis to say a message like Values in Thousands or Values in Millions etc.