Excel3个y轴图表的制作

Time(secs)Visc(cp)Temp(C)Speed(rpm)HeatCool3704855710156747.7594211077148.0594210697048.69588911-114497036913-1749.657035315550.11613517650.3515324191550.4515319211350.515815231250.515814251050.516112271150.516010291150.51609311150.51607331150.51605351150.451606371350.451594391350.451602411250.451601431250.41601441350.41600461250.351601481150.351590501250.31600521150.3160-1541150.251600561150.251600581150.251601601250.21600621150.215917641350.215934661250.316047681150.516059701350.7516067721251.1516071741251.516073761151.916080781352.416080801352.916079821353.216081841253.716087861154.1516086881354.616087891354.9515984911255.515989931155.9516089951356.416087971256.7516086991157.2160921011157.7159901031258.15159871051258.5160851071359.0516088040080012001600200024002800320036004000440001002003在一个图表内，ex cel是无法做出31、将版主帮你做的图表1，复制一个2、将图表1中的那个最低的序列删除3、将图表2中的另2个序列删除，只4、将图表1和图表3均对齐到某个单5、调整图表2，使坐标y 对齐1 0 91 35 9 .51 6 08 81 1 11 25 9 .9 51 6 08 71 1 31 16 0 .2 51 6 08 41 1 51 26 0 .7 51 6 08 61 1 71 36 1 .21 6 08 51 1 91 06 1 .61 6 08 61 2 11 26 1 .91 5 98 51 2 31 36 2 .3 51 6 08 71 2 51 36 2 .81 6 08 61 2 71 16 3 .2 51 6 08 51 2 91 26 3 .5 51 6 08 51 3 11 26 41 6 08 91 3 21 26 4 .4 51 6 08 61 3 41 36 4 .91 6 08 41 3 61 46 5 .1 51 6 08 51 3 81 56 5 .61 5 98 91 4 01 56 6 .0 51 6 08 71 4 21 86 6 .51 6 08 31 4 42 16 6 .81 6 08 11 4 62 86 7 .21 6 08 71 4 84 46 7 .71 6 08 31 5 07 16 8 .11 6 08 11 5 21 3 26 8 .41 6 07 91 5 42 4 66 8 .8 51 6 08 31 5 64 1 56 9 .31 5 98 11 5 86 5 06 9 .7 51 5 97 91 6 09 6 67 0 .0 51 5 97 41 6 21 3 5 17 0 .4 51 6 08 01 6 41 7 4 17 0 .8 51 6 08 01 6 62 0 6 17 1 .2 51 6 07 91 6 82 3 2 57 1 .5 51 6 07...