excel如何做出3个Y轴图表 | excel三座標軸
2 1:ѡҪΪڶY᷽ߣ˫ڳֵѡУᡱѡҰĬϵġᡱѡΪҪ 2:ѡ--ͼ-Զ-ͼҲʵ֡ 3Yͼhttp://www.cqvip.com/onlineread/onlineread.asp?ID=25568626&[1];SUID=EGBNBFDHDNCBCOPIBOLGEMCBCDOIPNFP 巽˫YͼͨҪʹʵ֣Ҫ3YYͼͨӸϵлԶķͼ£1츨ͼݣԭʼص㣬ԽݻҪϣݷŴ100ݹͬڴҪϡF3Ԫ빫ʽ=A3F6ԪΪǩݣG3Ԫ빫ʽ=C3G6ԪΪϵݣH3Ԫ빫ʽ=B3H6ԪΪϵݣI3Ԫ빫ʽ=D3*100I6ԪΪϵݡF7:I7Ϊ˿ճλ÷Yᡣ2Yݣԭʼ4࣬4֮1հYᣬ˿ԼYXֵΪ4.7YˮƽĽλãK3:K9ԪL3:L9Ԫ06010ıΪYYֵ3ͼѡG2:I7Ԫ롱ѡͼͼͼбУѡݱǵͼ4ǩݣҼͼѡݡˮƽǩµġ༭ťǩѡF3:F7Ԫȷ˳ǩԻȷ˳ѡԴԻ5ʽͼɾߣͼС߿ɫ6ͼͣҼϵСϵͼ͡XYɢͼֱߺݱǵɢͼȷ˳ͼ͡ԻͬķʡϵиΪֱߺݱǵɢͼ7ӡYᡱϵУҼͼѡݡӡϵơ롰YᡱXϵֵѡK3:K9ԪYϵֵѡL3:L9Ԫȷ˳༭ϵСԻȷ˳ѡԴԻ8ʽҪҼҪʽɫѡʵߡɫΪɫرաʽԻҪʼ...
2
1:ѡҪΪڶY᷽ߣ˫ڳֵѡУᡱѡҰĬϵġᡱѡΪҪ
2:ѡ--ͼ-Զ-ͼҲʵ֡
3Yͼ
http://www.cqvip.com/onlineread/onlineread.asp?ID=25568626&[1];SUID=EGBNBFDHDNCBCOPIBOLGEMCBCDOIPNFP
巽
˫YͼͨҪʹʵ֣Ҫ3YYͼͨӸϵлԶķͼ
£
1츨ͼݣԭʼص㣬ԽݻҪϣݷŴ100ݹͬڴҪϡF3Ԫ빫ʽ=A3F6ԪΪǩݣG3Ԫ빫ʽ=C3G6ԪΪϵݣH3Ԫ빫ʽ=B3H6ԪΪϵݣI3Ԫ빫ʽ=D3*100I6ԪΪϵݡF7:I7Ϊ˿ճλ÷Yᡣ
2Yݣԭʼ4࣬4֮1հYᣬ˿ԼYXֵΪ4.7YˮƽĽλãK3:K9ԪL3:L9Ԫ06010ıΪYYֵ
3ͼѡG2:I7Ԫ롱ѡͼͼͼбУѡݱǵͼ
4ǩݣҼͼѡݡˮƽǩµġ༭ťǩѡF3:F7Ԫȷ˳ǩԻȷ˳ѡԴԻ
5ʽͼɾߣͼС߿ɫ
6ͼͣҼϵСϵͼ͡XYɢͼֱߺݱǵɢͼȷ˳ͼ͡ԻͬķʡϵиΪֱߺݱǵɢͼ
7ӡYᡱϵУҼͼѡݡӡϵơ롰YᡱXϵֵѡK3:K9ԪYϵֵѡL3:L9Ԫȷ˳༭ϵСԻȷ˳ѡԴԻ
8ʽҪҼҪʽɫѡʵߡɫΪɫرաʽԻҪʼѡ塱ɫΪɫ
9ʽҪҼҪʽֵΪ̶ֵ60Ҫ̶ȵλΪ̶ֵ10֡ѡڡʽ롱µı롰0!%;;0ӡɫѡʵߡɫΪɫرաʽԻҪʼѡ塱ɫΪɫ
References http://www.cqvip.com/onlineread/onlineread.asp?ID=25568626& (www.cqvip.com)