Dec 27 2018 11:00 AM
I need to create a chart for a client that uses these formats, such as $0.2B or $10M and since it's a bar chart, I need it to pick up the values.
Dec 27 2018 01:48 PM
SolutionYou could use a custom cell format for your source data, not sure exactly where you want to break from M to B or how much you want the displayed numbers rounded though. Ex:
[>99999999]#.##,,," B";[>99999]#.##,," M"
Jan 03 2019 11:14 PM
Thank you for your response, but I'm not sure how to use your custom cell formula.
Jan 03 2019 11:30 PM
Nevermind, I figured it out. Thanks again. It was a big help!
Dec 27 2018 01:48 PM
SolutionYou could use a custom cell format for your source data, not sure exactly where you want to break from M to B or how much you want the displayed numbers rounded though. Ex:
[>99999999]#.##,,," B";[>99999]#.##,," M"