on 12-29-2014 4:25 PM
Hello all,
I have this chart (image attached) which has very high numbers (billions). I would like to round them to make it more clear.
For example : $ 42,000,000,000 --> M$ 42,000
I was not able to find a good solution, only to divide the numbers but the amounts are wrong then.
Thank you for reply in advance!!
Hi,
I think the easiest thing to do would be to use the Format Chart/Value Axis/Design option called:
Unit Scale Factor
Set this to "9" and it will change the value axis display to show the number in Billions.
Then within the same section, you could set a Custom Format Pattern (under the Number heading at the bottom)
Using Pattern "# B" would display the number as
10 B
That should make it a little prettier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try dividing your measure by 1,000,000,000 and use it on your chart
Cheers,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.