Excel chart changing the axis to millions and billions

[Declamatory]

Good morning,

I have an excel chart and rather than showing numbers with lots of zeros I'm wanting the chart to reflect in millions and billions.

I have the millions sorted using the following custom format "US"$ #,###,,"m"; but this is showing 1 billion and US$ 1,000m where I would like it to change to US$ 1bn

So I need the chart to show millions where the figure is below a billion but then change when it goes over 1 billion

Is there any way this can be done?

Thanks

 

[pgc01]

Hi

Try:

[>=1000000000] "US"$ #,###,,,"b";"US"$ #,###,,"m"