ãå¨excel2010ä¸ï¼ä¸ç»´é¥¼å¾æ¯é¥¼å¾çä¸ç§ç±»åï¼æä¹æè½å¶ä½åºè¿ç§ç±»åçå¾å½¢å¢?ä¸é¢å°±è·å¦ä¹ å¦å°ç¼ä¸èµ·æ¥ççå¶ä½ä¸ç»´é¥¼å¾çæ¹æ³å§ï¼å¸æå¯¹ä½ æ帮å©ï¼
ããexcel2010å¶ä½ä¸ç»´é¥¼å¾çæ¥éª¤
ãã1.é¦å
éä¸éè¦ç»å¶3D饼å¾çæ°æ®ï¼ç¶åè¿å
¥âæå
¥âèåï¼ç¹å»â饼å¾â-âä¸ç»´é¥¼å¾âã
ãã2.å®æåä¸è¿°æä½åå³å¯å¾å°ä¸å¾ã
ãã3.åå»é¥¼å¾å¼¹åºâ设置æ°æ®ç¹æ ¼å¼â对è¯æ¡ã
ãã左侧éæ©âç³»åé项âï¼å³ä¾§éè¿æå¨â第ä¸
æåºèµ·å§è§åº¦âå¯è°æ´ç¬¬ä¸å饼å¾çæ¹ä½ã
ããç³»ç»é»è®¤é¥¼å¾çæå为顺æ¶éæ¹åï¼ç¬¬ä¸å饼å¾çå³è¾¹ç为æ´ä¸ªé¥¼å¾çèµ·å§ç¹(å³èµ·å§è§åº¦=0)ã
ãã4.è°æ´âç³»åé项âä¸çâ饼å¾å离ç¨åº¦âå¯å°åååå¼(éä¸ææ饼ååå离çææå¾)ã
ãã5.å¦æåªéè¦å离å
¶ä¸çé¨å饼åï¼é£ä¹åç¬éä¸é£å 个饼åï¼ç¶åå¨âç¹çç¸åâä¸è¿è¡å离å³å¯ã
ãã6.éè¿ä¿®æ¹âå¡«å
âæ¹å¼å¯æ¹å饼å¾çé¢è²æ纹çç(å¯ä¸ºå饼ååç¬è®¾ç½®)ã
ãã7.以ä¸å³ä¸ºè¿è¡å¾æ¡å¡«å
åçææå¾ã
ãã8.æ¤å¤ï¼è¿å¯å¨âä¸ç»´æ转âä¸ï¼ä¿®æ¹Yçæ°å¼è°æ´ä¿¯è§è§åº¦ã
ãã9.å°âä¸ç»´æ转âä¸çYä»30ä¿®æ¹å°20åçææå¾(90=2D
å¹³é¢å¾)ã
ãã10.æåå¨âå¾æ å·¥å
·âèåçâå¸å±âä¸ï¼ç¹å»âæ°æ®æ ç¾â-âæä½³å¹é
âå¯æ¾ç¤ºå饼åçæ°å¼æ¯ä¾ã
ãã11.æ·»å æ°æ®æ ç¾åçææå¾å¦ä¸ï¼
ããexcel2010å¶ä½é¥¼å¾çæç¨
ããå¶ä½é¥¼å¾æ¥éª¤1ï¼é¼ æ å³é®æ°å»ºExcel空ç½ææ¡£ï¼å¹¶éæ°å½å为â饼å¾.xlsxâ;
ããå¶ä½é¥¼å¾æ¥éª¤2ï¼åå»â饼å¾.xlsxâ,æå¼Excel空ç½é¡µï¼ç¶åä¾æ¬¡æä½âæå
¥--->;饼å¾âï¼éæ©å
¶ä¸çä¸ç§é¥¼å¾
ããå¶ä½é¥¼å¾æ¥éª¤3ï¼åå»â饼å¾âå¾ä¾ï¼éæ©ç¬¬ä¸ç§åºæ¬ç饼å¾æ¨¡åï¼ç¹å»ä¹
ããå¶ä½é¥¼å¾æ¥éª¤4ï¼è¿æ¶ï¼å¨Excel空ç½ææ¡£ä¸çæäºé¥¼å¾å¾æ¡ï¼å¦å¾æ示
ããå¶ä½é¥¼å¾æ¥éª¤5ï¼å¨é¥¼å¾å¾æ¡ä¸æ¹æ°å»ºæ°æ®æºï¼æ°æ®æºçæ ¼å¼è¦æ»¡è¶³é¥¼å¾çæ°æ®æ ¼å¼
ããå¶ä½é¥¼å¾æ¥éª¤6ï¼å¨å¾æ¡ä¸æ¹ï¼é¼ æ å³é®ï¼éæ©âéæ©æ°æ®(E)...âè¿é¡¹ï¼å¼¹åºéæ©æ°æ®æºçªå£ï¼å¹¶å
¨éå¾æ¡ä¸æ¹çæ°å»ºçæ°æ®æºï¼çæ饼å¾
ããå¶ä½é¥¼å¾æ¥éª¤7ï¼æåçæäºé¥¼å¾ï¼