Scale a long number

Question

I have a horizontal bar chart showing a long dollar figure (billions) and would like to scale it down it to $#.#B. I know this can be done for a tile but cannot determine how to show the label with an abbreviated value on a chart.

I've tried the ROUND function and no luck.

Any suggestions would be appreciated.

Thanks.

Tonya H · Answer

Ah…clever. Didn't think to do that! Thank you for responding!

Nathan CCC · Answer

Hi,

Use division. If x is amount in unit of currency then add a calculated column with formula x/1000000 is millions etc. then use the calculated column in your chart.