numbers axis formatting in charts

[bertjeiv]

Hello all,

I have made a nice script which automatically makes charts of certain data.
on my X-axis i have dates which i can format easily the way i want to but on the Y-axis I just have big numbers and want to display it as follows:
1000 in the data table => 1k on the chart Y-axis
1,000,000 in the data table => 1M on the chart Y-axis
100,000,000 in the data table => 100M on the chart

I have a lot of data in 100millions so the number itself takes too much space

I cannot find any usable option in the "format axis" screen.

Thanks for the help!

 

[pgc01]

Hi

Use the custom format:

[>=1000000]0,,"M";[>=1000]0,"K";0

 

[bertjeiv]

thanks! its working beautifully!

 

[pgc01]

I'm glad it helped. Thanks for the feedback.