Here is the example of REPT function. To create BarChart
Units | Days | Share | Function |
100 | Sunday | ||||| 5% | =REPT("|",100*A2/$A$9) &" "& TEXT(A2/$A$9,"0%") |
150 | Monday | ||||||| 8% | =REPT("|",100*A3/$A$9) &" "& TEXT(A3/$A$9,"0%") |
450 | Tuesday | |||||||||||||||||||||| 23% | =REPT("|",100*A4/$A$9) &" "& TEXT(A4/$A$9,"0%") |
300 | Wednesday | ||||||||||||||| 15% | =REPT("|",100*A5/$A$9) &" "& TEXT(A5/$A$9,"0%") |
300 | Thursday | ||||||||||||||| 15% | =REPT("|",100*A6/$A$9) &" "& TEXT(A6/$A$9,"0%") |
400 | Friday | |||||||||||||||||||| 20% | =REPT("|",100*A7/$A$9) &" "& TEXT(A7/$A$9,"0%") |
300 | Saturday | ||||||||||||||| 15% | =REPT("|",100*A8/$A$9) &" "& TEXT(A8/$A$9,"0%") |
2000 | Total |
Now, send attachments up to 25MB with Yahoo! India Mail. Learn how.