ä¸ã.建ç«çªä½æ§ä»¶
1ãç¹å»å¼åå·¥å
·ââæå
¥ââçªä½æ§ä»¶ã
2ãæ»å¨æ¡çªä½æ§ä»¶ï¼å³å»ââ设置æ§ä»¶æ ¼å¼ãå¦å¾æ示ï¼è¿è¡è®¾ç½®ã
3ãç»åæ¡çªä½æ§ä»¶ï¼å³å»ââ设置æ§ä»¶æ ¼å¼ãå¦å¾æ示ï¼è¿è¡è®¾ç½®ã
äºãå®ä¹å称建ç«Xè½´æ°æ®æº
1ãç¹å»å
¬å¼ââå称管çå¨ï¼å®ä¹å称建ç«Xè½´æ°æ®æºã
2ãå®ä¹å为Xè½´çå称
Xè½´å¼ç¨ä½ç½®ââ=OFFSET(Sheet1!$A$2,,Sheet1!$B$6,,Sheet1!$B$7-Sheet1!$B$6+1)
ä¸ãå®ä¹å称建ç«å¨ææ°æ®æº
1ãå京åå
¬å¸=OFFSET(Xè½´,Sheet1!$H$6,)ï¼ä¸æµ·åå
¬å¸=OFFSET(Xè½´,Sheet1!$H$6,)
2ãå¦å¾æ示ï¼éè¿æ»å¨æ¡æ§ä»¶æ¥æ§å¶Xè½´çæ°æ®ï¼æ份ï¼ââä¸æµ·åå
¬å¸çæ°æ®ââå京åå
¬å¸çæ°æ®ï¼éè¿ç»åçªä½æ§ä»¶æ¥æ§å¶å
¬å¸å称ã
å
¬å¼è§£éï¼
Xè½´å¼ç¨ä½ç½®ââ=OFFSET(Sheet1!$A$2,,Sheet1!$B$6,,Sheet1!$B$7-Sheet1!$B$6+1)
以A2ï¼åå
¬å¸ï¼ä¸ºåç
§ç³»ââè¡ä¸å移ï¼åå移B6ï¼è¿é为2ï¼ââè¿å1è¡ï¼B7-B6+1=5åï¼æ以æ¯2æå°6æ
å京åå
¬å¸=OFFSET(Xè½´,Sheet1!$H$6,)
以ä¸é¢å®ä¹çXè½´ï¼æ¯åºåï¼ä¸é¢æ¯åå
æ ¼ï¼ä¸ºåç
§ç³»ââè¡å移ï¼å移éç±åå
æ ¼H6æ§å¶ã
H6æå¨åå
æ ¼åå¯ä»¥æ§å¶ââç»åçªä½æ§ä»¶ââå
¬å¸å称ã
åãå©ç¨å®ä¹å称å建å¾è¡¨
1ãç¹å»å¾è¡¨å·¥å
·ââ设计ââéæ©æ°æ®ã
2ãè½´æ ç¾
=sheet1ï¼Xè½´
sheet1ï¼ä¸ºåºå®å½¢å¼ââX轴为å®ä¹çå称ï¼æ¯å¨æçæ份æ°æ®
ç³»åå¼
=sheet1ï¼å京åå
¬å¸
sheet1ï¼ä¸ºåºå®å½¢å¼ââå京åå
¬å¸ä¸ºå®ä¹çå称ï¼æ¯å¨æçè¥ä¸é¢æ°æ®ã
äºãå¾è¡¨çç¾å
1è¿è¡å¾è¡¨çç¾åã
温馨提示:答案为网友推荐,仅供参考