Not only graph in the ribbon for ready use but also in the formula too. This method is very simple to use and look unconventionally.
Thus, I am going to tell you how to create the mentioned graph with formula as below.
1. Make your own table in your Excel worksheet as same as mine. (See the image above)
2. Change font in cells between “D3” and “D8” to “Webdings” style.
3. Input formula =REPT(“M”,C3) into cell “D3”
4. Copy, paste and apply the formula as of no.3 above for the rest of cells between “D4” and “D8”. They will be liked these below after completion the formula.
"D3" =REPT(“M”,C3)
"D4" =REPT(“M”,C4)
"D5" =REPT(“M”,C5)
"D6" =REPT(“M”,C6)
"D7" =REPT(“M”,C7)
"D8" =REPT(“M”,C8)
Alright, then it should appear the graph image with men symbols as image shown above.
See more another tips:
Thus, I am going to tell you how to create the mentioned graph with formula as below.
1. Make your own table in your Excel worksheet as same as mine. (See the image above)
2. Change font in cells between “D3” and “D8” to “Webdings” style.
3. Input formula =REPT(“M”,C3) into cell “D3”
4. Copy, paste and apply the formula as of no.3 above for the rest of cells between “D4” and “D8”. They will be liked these below after completion the formula.
"D3" =REPT(“M”,C3)
"D4" =REPT(“M”,C4)
"D5" =REPT(“M”,C5)
"D6" =REPT(“M”,C6)
"D7" =REPT(“M”,C7)
"D8" =REPT(“M”,C8)
Alright, then it should appear the graph image with men symbols as image shown above.
See more another tips:
- Trick How To Delete The Same Data In Multiple Places With An Easy Way
- Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells
- Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String
- VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row
- Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First Row/Column
- Formula “LOOK UP” For Using Approximate Match Values Sorted Ascending Order In a List
- Method of Extract the Specified Characters from the End of Text String Content
- How To Extract The Specified Characters From The Left Of The Text String In Active Cell
- Delete Unwanted Characters and or Blank Space From The Left Side Of Contents In Active Cell
- Removes Characters and Blank Space From The Right Side Of Contents In Cell | Xcel-Guru
It's REPT("m",C3) instead of REPT("M",C3)
ReplyDelete