ä¸è¬æ
åµï¼è¿åº¦æ¡æ¯éè¿EXCELçå¾æ åè½æ¥å®ç°ï¼ä½å¦æä½ åªéè¦æ¾ç¤ºä¸ä¸ªåä¸çæ±å½¢è¿åº¦æ¡ï¼èä¸æ¨ªçæ¾ç¤ºï¼å¦æä¾ç¶éç¨å¾æ çå½¢å¼ï¼ä¼¼ä¹ä¸å¤§ç¾è§ï¼ä¸å¤ªåè°ã
ç°å¨ï¼æ们æ¥éè¿ä¸ä¸ªå½æ°æ¥å®ç°ç´æ¥å¨ä¸ä¸ªåå
æ ¼éæ¾ç¤ºè¿åº¦æ¡ãæ´ä¸ªè¿ç¨æ¯è¿æ ·çï¼æ个æ¯æ¹ï¼å·¥ç¨æ»éæ¯500åè½½é¢ï¼å½åæ们å®æäºå
¶ä¸ç200åï¼é£å·¥ç¨è¿å±åºè¯¥æ¯40%ãå¦ä¸è¡¨
A B C D
æ¥æ å·¥ç¨æ»é å½åå®ææ°é å·¥ç¨è¿å±
2008-03-01 500 200 |||| 70%
2008-03-08 500 250 ||||| 80%
使ç¨çå½æ°æ¯=rept("|",C2/B2*10)&" "&text(C2/B2,"0.00%")
尽管å¦æ¤æ¾ç¤ºç¥æ¾ç²ç³ï¼è¿åº¦æ¡å¯¹äºå50%ï¼51%ï¼52%ãããç没æåºå«ï¼ä½åºè¯¥è¯´è¿æ¯ç»è¿åº¦è¡¨å¢è²ä¸å°ã
http://blog.csdn.net/arbin_he/archive/2011/03/18/6258060.aspx