Sunday, November 15, 2009

Create Barchart using "REPT" function.

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    

 

http://www.vbatalent.blogspot.com



Now, send attachments up to 25MB with Yahoo! India Mail. Learn how.