Looks matter both in life and data visualization—you never get a second chance to make a first impression.
Numbers in excel constitute the largest data type and knowing how to format them either on Charts or on tables is a big plus towards quicker decision making.
Below are some tips on custom formatting;
Custom Number Format on tables
For example, how do you display decimals and change font color when a number is less than 1 in the table below?
How to go about it:
- Highlight the numbers and press CTRL+1 on your Keyboard
- Go to—Number tab, select category as “Custom”
- Write your format
[Blue][>1]##0;[Red]##0.00
Just that and you have a better-looking table
Custom formatting number on charts
What if you had a chart like below and you need to format Y axis so that positive numbers are colored Green, negatives red, and keep zeros in their default?
How to go about it:
- Right-click axis area and Format axis
- Go to Numbers, then Custom and Paste below format to Format code–then click Add
       [Green][>1]#, ##0; [Red] (#, ##0); #, ##0
Just like that, you have beautiful looking chart
What if you want to change the font color for numbers from 4000 and above?
       [Green][>=4000]#, ##0; [Red] (#, ##0); #, ##0
The same trick can be used to format Series data labels to show Decreaseâ–Ľ Â Increaseâ–˛or Constant â—„â–ş
  [Blue] 0.00▲”%”;[Red] 0.00▼”%”;[Green]#0.00â—„â–ş”%”
or in a dashboard
Custom Number Formatting Worksheet
Further reading:
https://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/
To learn more about how to create characters https://www.alt-codes.net/
yĐľu’re in reality a just right webmaster.
The web site loading speed is Đ°mazing. It sort of feels that you’re â…ľÖ…ing any unique
trick. In addition, The contents are masterwork.
you’ve done a wonderful job in this matteĐł!
Thanks Hugh
І am extremely impressed with your writing ѕkills and also with the layout on your blog.
Is this a paid theme or did you moɗіfy it yourself? Either way қeep up
the nice quality writing, it is гare to see a great ƅloɡ like this one today.
Thanks Damon.
Generally ÓŹ don’t â…Ľearn post on blogs, however Ó€ wish to say that this write-up very compelled mе to check out and Ô€o it!
Your writing style has been surрrised me. Thank you, very
nice post.
Thanks Tamela. Hope you keep learning more