用于 xy 值数据的 Excel 图表类型或更好的工具

用于 xy 值数据的 Excel 图表类型或更好的工具

为了直观地显示我的计算值,我创建了具有以下结构的调试 csv 文件:

x;y;值

| x       | y       | res value1  | result value2  |
|---------|---------|-------------|----------------|
| -0.0500 | -0.0500 | -48746.6934 | -12185006.6746 |
| -0.0500 | -0.0450 | -48518.2139 | -12172120.4327 |
| -0.0500 | -0.0400 | -48289.7344 | -12159234.1909 |
| -0.0500 | -0.0350 | -48061.2550 | -12146347.9490 |
| -0.0500 | -0.0300 | -47832.7755 | -12133461.7071 |
| -0.0500 | -0.0250 | -47604.2960 | -12120575.4653 |
| -0.0500 | -0.0200 | -47375.8166 | -12107689.2234 |
| -0.0500 | -0.0150 | -47147.3371 | -12094802.9815 |
| -0.0500 | -0.0100 | -46918.8576 | -12081916.7397 |
| -0.0500 | -0.0050 | -46690.3782 | -12069030.4978 |
| -0.0500 | 0.0000  | -46452.7320 | -12056117.1726 |
| -0.0500 | 0.0050  | -7396.7654  | -10878601.5957 |
| -0.0500 | 0.0100  | -2376.1024  | -10720080.9840 |
| -0.0500 | 0.0150  | -2105.1354  | -10702854.9401 |
| -0.0500 | 0.0200  | -1840.9101  | -10685264.4170 |
| -0.0500 | 0.0250  | -1581.0432  | -10667460.0813 |
| -0.0500 | 0.0300  | -1325.2512  | -10649691.6832 |
| -0.0500 | 0.0350  | -1072.2842  | -10631954.5976 |
| -0.0500 | 0.0400  | -822.6089   | -10614503.6578 |
| -0.0500 | 0.0450  | -574.8753   | -10597180.6139 |
| -0.0500 | 0.0500  | -328.3333   | -122912.5000   |
| -0.0450 | -0.0500 | -48518.2139 | -12083653.1836 |
| -0.0450 | -0.0450 | -48289.7344 | -12070766.9417 |
| -0.0450 | -0.0400 | -48061.2550 | -12057880.6999 |
| -0.0450 | -0.0350 | -47832.7755 | -12044994.4580 |
| -0.0450 | -0.0300 | -47604.2960 | -12032108.2161 |
| -0.0450 | -0.0250 | -47375.8166 | -12019221.9743 |
| -0.0450 | -0.0200 | -47147.3371 | -12006335.7324 |
| -0.0450 | -0.0150 | -46918.8576 | -11993449.4905 |
| -0.0450 | -0.0100 | -46690.3782 | -11980563.2487 |
| -0.0450 | -0.0050 | -46461.8987 | -11967677.0068 |
| -0.0450 | 0.0000  | -46223.2942 | -11954755.6608 |
| -0.0450 | 0.0050  | -4159.0866  | -10686818.5098 |
| -0.0450 | 0.0100  | -2136.6813  | -10617737.6805 |
| -0.0450 | 0.0150  | -1863.1435  | -10599835.2512 |
| -0.0450 | 0.0200  | -1597.1223  | -10581602.8635 |
| -0.0450 | 0.0250  | -1336.2345  | -10563253.2258 |
| -0.0450 | 0.0300  | -1079.0842  | -10544879.7235 |
| -0.0450 | 0.0350  | -826.4923   | -10526896.7837 |
| -0.0450 | 0.0400  | -575.8753   | -10508951.5314 |
| -0.0450 | 0.0450  | -327.9167   | -122806.9583   |
| -0.0450 | 0.0500  | -82.8330    | -10474139.0060 |
| -0.0400 | -0.0500 | -48289.7344 | -11982299.6926 |
| -0.0400 | -0.0450 | -48061.2550 | -11969413.4508 |
| -0.0400 | -0.0400 | -47832.7755 | -11956527.2089 |
| -0.0400 | -0.0350 | -47604.2960 | -11943640.9670 |
| -0.0400 | -0.0300 | -47375.8166 | -11930754.7252 |
| -0.0400 | -0.0250 | -47147.3371 | -11917868.4833 |
| -0.0400 | -0.0200 | -46918.8576 | -11904982.2414 |
| -0.0400 | -0.0150 | -46690.3782 | -11892095.9996 |
| -0.0400 | -0.0100 | -46461.8987 | -11879209.7577 |
| -0.0400 | -0.0050 | -46233.4192 | -11866323.5158 |
| -0.0400 | 0.0000  | -45993.6064 | -11853390.6073 |
| -0.0400 | 0.0050  | -2181.9646  | -10532775.4731 |
| -0.0400 | 0.0100  | -1895.0435  | -10515074.5854 |
| -0.0400 | 0.0150  | -1619.2098  | -10496405.4581 |
| -0.0400 | 0.0200  | -1351.0512  | -10477379.6850 |
| -0.0400 | 0.0250  | -1089.0301  | -10458382.2973 |
| -0.0400 | 0.0300  | -831.4589   | -10439513.4512 |
| -0.0400 | 0.0350  | -578.2711   | -10421045.9802 |
| -0.0400 | 0.0400  | -327.3333   | -122658.6667   |
| -0.0400 | 0.0450  | -79.7289    | -10384849.8715 |
| -0.0400 | 0.0500  | 165.3756    | -10367430.3588 |
| -0.0350 | -0.0500 | -48061.2550 | -11880946.2016 |
| -0.0350 | -0.0450 | -47832.7755 | -11868059.9598 |
| -0.0350 | -0.0400 | -47604.2960 | -11855173.7179 |
| -0.0350 | -0.0350 | -47375.8166 | -11842287.4760 |
| -0.0350 | -0.0300 | -47147.3371 | -11829401.2342 |
| -0.0350 | -0.0250 | -46918.8576 | -11816514.9923 |
| -0.0350 | -0.0200 | -46690.3782 | -11803628.7504 |
| -0.0350 | -0.0150 | -46461.8987 | -11790742.5086 |
| -0.0350 | -0.0100 | -46233.4192 | -11777856.2667 |
| -0.0350 | -0.0050 | -46004.9398 | -11764970.0248 |
| -0.0350 | 0.0000  | -45023.8870 | -11729829.3453 |
| -0.0350 | 0.0050  | -1943.2101  | -10430753.5862 |
| -0.0350 | 0.0100  | -1651.0390  | -10412005.0735 |
| -0.0350 | 0.0150  | -1371.4179  | -10392209.8525 |
| -0.0350 | 0.0200  | -1101.7134  | -10372322.4231 |
| -0.0350 | 0.0250  | -838.5589   | -10352561.7854 |
| -0.0350 | 0.0300  | -580.5378   | -10333109.3977 |
| -0.0350 | 0.0350  | -326.5833   | -122467.6250   |
| -0.0350 | 0.0400  | -76.8330    | -10295605.4661 |
| -0.0350 | 0.0450  | 170.8256    | -10277432.4846 |
| -0.0350 | 0.0500  | 416.1801    | -10259665.9303 |
| -0.0300 | -0.0500 | -47832.7755 | -11779592.7106 |
| -0.0300 | -0.0450 | -47604.2960 | -11766706.4688 |
| -0.0300 | -0.0400 | -47375.8166 | -11753820.2269 |
| -0.0300 | -0.0350 | -47147.3371 | -11740933.9850 |
| -0.0300 | -0.0300 | -46918.8576 | -11728047.7432 |
| -0.0300 | -0.0250 | -46690.3782 | -11715161.5013 |
| -0.0300 | -0.0200 | -46461.8987 | -11702275.2594 |
| -0.0300 | -0.0150 | -46233.4192 | -11689389.0176 |
| -0.0300 | -0.0100 | -46004.9398 | -11676502.7757 |
| -0.0300 | -0.0050 | -45776.4603 | -11663616.5338 |
| -0.0300 | 0.0000  | -41791.0999 | -11538381.7385 |
| -0.0300 | 0.0050  | -1701.1682  | -10328399.1057 |
| -0.0300 | 0.0100  | -1402.5845  | -10308181.3534 |
| -0.0300 | 0.0150  | -1120.0801  | -10287125.8407 |
| -0.0300 | 0.0200  | -847.7923   | -10266011.7863 |
| -0.0300 | 0.0250  | -584.1878   | -10245484.1903 |
| -0.0300 | 0.0300  | -325.6000   | -122216.3333   |
| -0.0300 | 0.0350  | -72.2997    | -10205911.2170 |
| -0.0300 | 0.0400  | 177.7089    | -10186999.1939 |
| -0.0300 | 0.0450  | 425.1259    | -10168525.1082 |
| -0.0300 | 0.0500  | 669.2512    | -10150816.0851 |
| -0.0250 | -0.0500 | -47604.2960 | -11678239.2196 |
| -0.0250 | -0.0450 | -47375.8166 | -11665352.9778 |
| -0.0250 | -0.0400 | -47147.3371 | -11652466.7359 |
| -0.0250 | -0.0350 | -46918.8576 | -11639580.4940 |
| -0.0250 | -0.0300 | -46690.3782 | -11626694.2522 |
| -0.0250 | -0.0250 | -46461.8987 | -11613808.0103 |
| -0.0250 | -0.0200 | -46233.4192 | -11600921.7684 |
| -0.0250 | -0.0150 | -46004.9398 | -11588035.5266 |
| -0.0250 | -0.0100 | -45776.4603 | -11575149.2847 |
| -0.0250 | -0.0050 | -45547.9808 | -11562263.0428 |
| -0.0250 | 0.0000  | -38557.4669 | -11346914.7255 |
| -0.0250 | 0.0050  | -1454.7179  | -10225503.7709 |
| -0.0250 | 0.0100  | -1149.0259  | -10203296.7895 |
| -0.0250 | 0.0150  | -862.6256   | -10180482.4539 |
| -0.0250 | 0.0200  | -589.0878   | -10158132.2745 |
| -0.0250 | 0.0250  | -324.1667   | -121847.9167   |
| -0.0250 | 0.0300  | -66.6289    | -10115885.6241 |
| -0.0250 | 0.0350  | 186.4923    | -10095968.8197 |
| -0.0250 | 0.0400  | 435.6926    | -10076817.0674 |
| -0.0250 | 0.0450  | 682.0845    | -10058256.5860 |
| -0.0250 | 0.0500  | 925.9390    | -10040305.9483 |
| -0.0200 | -0.0500 | -47375.8166 | -11576885.7287 |
| -0.0200 | -0.0450 | -47147.3371 | -11563999.4868 |
| -0.0200 | -0.0400 | -46918.8576 | -11551113.2449 |
| -0.0200 | -0.0350 | -46690.3782 | -11538227.0031 |
| -0.0200 | -0.0300 | -46461.8987 | -11525340.7612 |
| -0.0200 | -0.0250 | -46233.4192 | -11512454.5193 |
| -0.0200 | -0.0200 | -46004.9398 | -11499568.2775 |
| -0.0200 | -0.0150 | -45776.4603 | -11486682.0356 |
| -0.0200 | -0.0100 | -45547.9808 | -11473795.7937 |
| -0.0200 | -0.0050 | -45319.5014 | -11460909.5519 |
| -0.0200 | 0.0000  | -35322.3506 | -11155405.6708 |
| -0.0200 | 0.0050  | -1200.8551  | -10121560.4049 |
| -0.0200 | 0.0100  | -886.6423   | -10096422.5797 |
| -0.0200 | 0.0150  | -596.6836   | -10071357.1400 |
| -0.0200 | 0.0200  | -322.0000   | -121286.6667   |
| -0.0200 | 0.0250  | -58.0622    | -10025018.8750 |
| -0.0200 | 0.0300  | 199.4589    | -10003615.6539 |
| -0.0200 | 0.0350  | 450.9634    | -9983522.2246  |
| -0.0200 | 0.0400  | 698.9845    | -9964209.2535  |
| -0.0200 | 0.0450  | 944.0848    | -9945632.5846  |
| -0.0200 | 0.0500  | 1186.5601   | -9927791.8948  |
| -0.0150 | -0.0500 | -47147.3371 | -11475532.2377 |
| -0.0150 | -0.0450 | -46918.8576 | -11462645.9958 |
| -0.0150 | -0.0400 | -46690.3782 | -11449759.7539 |
| -0.0150 | -0.0350 | -46461.8987 | -11436873.5121 |
| -0.0150 | -0.0300 | -46233.4192 | -11423987.2702 |
| -0.0150 | -0.0250 | -46004.9398 | -11411101.0283 |
| -0.0150 | -0.0200 | -45776.4603 | -11398214.7865 |
| -0.0150 | -0.0150 | -45547.9808 | -11385328.5446 |
| -0.0150 | -0.0100 | -45319.5014 | -11372442.3027 |
| -0.0150 | -0.0050 | -45091.0219 | -11359556.0609 |
| -0.0150 | 0.0000  | -32084.2718 | -10963788.0015 |
| -0.0150 | 0.0050  | -934.6256   | -10015451.2889 |
| -0.0150 | 0.0100  | -610.5628   | -9985862.3387  |
| -0.0150 | 0.0150  | -318.3500   | -120329.2083   |
| -0.0150 | 0.0200  | -44.4789    | -9932633.5008  |
| -0.0150 | 0.0250  | 217.9589    | -9909377.9881  |
| -0.0150 | 0.0300  | 473.0009    | -9887778.6734  |
| -0.0150 | 0.0350  | 723.0845    | -9867417.5877  |
| -0.0150 | 0.0400  | 968.5890    | -9848389.4917  |
| -0.0150 | 0.0450  | 1211.9435   | -9829963.5207  |
| -0.0150 | 0.0500  | 1452.5479   | -9812435.6746  |
| -0.0100 | -0.0500 | -46918.8576 | -11374178.7467 |
| -0.0100 | -0.0450 | -46690.3782 | -11361292.5048 |
| -0.0100 | -0.0400 | -46461.8987 | -11348406.2629 |
| -0.0100 | -0.0350 | -46233.4192 | -11335520.0211 |
| -0.0100 | -0.0300 | -46004.9398 | -11322633.7792 |
| -0.0100 | -0.0250 | -45776.4603 | -11309747.5373 |
| -0.0100 | -0.0200 | -45547.9808 | -11296861.2955 |
| -0.0100 | -0.0150 | -45319.5014 | -11283975.0536 |
| -0.0100 | -0.0100 | -45091.0219 | -11271088.8117 |
| -0.0100 | -0.0050 | -44862.5424 | -11258202.5699 |
| -0.0100 | 0.0000  | -28838.7846 | -10771787.5614 |
| -0.0100 | 0.0050  | -643.3211   | -9903794.8605  |
| -0.0100 | 0.0100  | -311.0000   | -118355.8333   |
| -0.0100 | 0.0150  | -20.2705    | -9836830.9392  |
| -0.0100 | 0.0200  | 249.4923    | -9810484.5724  |
| -0.0100 | 0.0250  | 507.5676    | -9787161.9659  |
| -0.0100 | 0.0300  | 758.5845    | -9765889.0886  |
| -0.0100 | 0.0350  | 1004.1057   | -9746403.7843  |
| -0.0100 | 0.0400  | 1246.7101   | -9727886.1882  |
| -0.0100 | 0.0450  | 1486.2479   | -9710482.9255  |
| -0.0100 | 0.0500  | 1724.0357   | -9693724.6212  |
| -0.0050 | -0.0500 | -46690.3782 | -11272825.2557 |
| -0.0050 | -0.0450 | -46461.8987 | -11259939.0138 |
| -0.0050 | -0.0400 | -46233.4192 | -11247052.7719 |
| -0.0050 | -0.0350 | -46004.9398 | -11234166.5301 |
| -0.0050 | -0.0300 | -45776.4603 | -11221280.2882 |
| -0.0050 | -0.0250 | -45547.9808 | -11208394.0463 |
| -0.0050 | -0.0200 | -45319.5014 | -11195507.8045 |
| -0.0050 | -0.0150 | -45091.0219 | -11182621.5626 |
| -0.0050 | -0.0100 | -44862.5424 | -11169735.3208 |
| -0.0050 | -0.0050 | -44634.0630 | -11156849.0789 |
| -0.0050 | 0.0000  | -25563.6683 | -10577145.1733 |
| -0.0050 | 0.0050  | -288.8333   | -112036.2500   |
| -0.0050 | 0.0100  | 35.8586     | -9729621.7005  |
| -0.0050 | 0.0150  | 312.6256    | -9698888.4899  |
| -0.0050 | 0.0200  | 570.0217    | -9674466.2064  |
| -0.0050 | 0.0250  | 817.5679    | -9653624.2145  |
| -0.0050 | 0.0300  | 1059.8098   | -9634825.3997  |
| -0.0050 | 0.0350  | 1298.5435   | -9617440.1891  |
| -0.0050 | 0.0400  | 1535.2521   | -9600887.3326  |
| -0.0050 | 0.0450  | 3510.7532   | -8767025.2325  |
| -0.0050 | 0.0500  | 6746.5779   | -7340758.3188  |
| 0.0000  | -0.0500 | -46452.7320 | -11166961.3480 |
| 0.0000  | -0.0450 | -46223.2942 | -11153608.7520 |
| 0.0000  | -0.0400 | -45993.6064 | -11140135.9476 |
| 0.0000  | -0.0350 | -45023.8870 | -10778845.3215 |
| 0.0000  | -0.0300 | -41791.0999 | -9353909.7932  |
| 0.0000  | -0.0250 | -38557.4669 | -7928574.9836  |
| 0.0000  | -0.0200 | -35322.3506 | -6502547.9657  |
| 0.0000  | -0.0150 | -32084.2718 | -5075163.1249  |
| 0.0000  | -0.0100 | -28838.7846 | -3644493.9299  |
| 0.0000  | -0.0050 | -25563.6683 | -2201800.2453  |
| 0.0000  | 0.0000  | 0.0000      | 0.0000         |
| 0.0000  | 0.0050  | 24985.9183  | 2076586.2870   |
| 0.0000  | 0.0100  | 28216.6180  | 3500516.0132   |
| 0.0000  | 0.0150  | 31447.3176  | 4924445.7395   |
| 0.0000  | 0.0200  | 34678.0173  | 6348375.4657   |
| 0.0000  | 0.0250  | 37908.7169  | 7772305.1919   |
| 0.0000  | 0.0300  | 41139.4166  | 9196234.9182   |
| 0.0000  | 0.0350  | 44370.1162  | 10620164.6444  |
| 0.0000  | 0.0400  | 45338.2731  | 10980699.2810  |
| 0.0000  | 0.0450  | 45566.7526  | 10993585.5228  |
| 0.0000  | 0.0500  | 45795.2320  | 11006471.7647  |
| 0.0050  | -0.0500 | -7396.7654  | 7183207.9751   |
| 0.0050  | -0.0450 | -4159.0866  | 8610229.3992   |
| 0.0050  | -0.0400 | -2181.9646  | 9444706.2181   |
| 0.0050  | -0.0350 | -1943.2101  | 9462010.1891   |
| 0.0050  | -0.0300 | -1701.1682  | 9480608.8789   |
| 0.0050  | -0.0250 | -1454.7179  | 9500848.8395   |
| 0.0050  | -0.0200 | -1200.8551  | 9523709.9564   |
| 0.0050  | -0.0150 | -934.6256   | 9550526.8232   |
| 0.0050  | -0.0100 | -643.3211   | 9584208.5026   |
| 0.0050  | -0.0050 | -288.8333   | -30936.2500    |
| 0.0050  | 0.0000  | 24985.9183  | 10416372.8816  |
| 0.0050  | 0.0050  | 43967.3963  | 10991849.0789  |
| 0.0050  | 0.0100  | 44195.8758  | 11004735.3208  |
| 0.0050  | 0.0150  | 44424.3552  | 11017621.5626  |
| 0.0050  | 0.0200  | 44652.8347  | 11030507.8045  |
| 0.0050  | 0.0250  | 44881.3142  | 11043394.0463  |
| 0.0050  | 0.0300  | 45109.7936  | 11056280.2882  |
| 0.0050  | 0.0350  | 45338.2731  | 11069166.5301  |
| 0.0050  | 0.0400  | 45566.7526  | 11082052.7719  |
| 0.0050  | 0.0450  | 45795.2320  | 11094939.0138  |
| 0.0050  | 0.0500  | 46023.7115  | 11107825.2557  |
| 0.0100  | -0.0500 | -2376.1024  | 9534771.1212   |
| 0.0100  | -0.0450 | -2136.6813  | 9552083.6755   |
| 0.0100  | -0.0400 | -1895.0435  | 9570173.6882   |
| 0.0100  | -0.0350 | -1651.0390  | 9589028.7843   |
| 0.0100  | -0.0300 | -1402.5845  | 9609332.4220   |
| 0.0100  | -0.0250 | -1149.0259  | 9631101.7784   |
| 0.0100  | -0.0200 | -886.6423   | 9655249.8640   |
| 0.0100  | -0.0150 | -610.5628   | 9682491.3559   |
| 0.0100  | -0.0100 | -311.0000   | -35589.1667    |
| 0.0100  | -0.0050 | 35.8586     | 9748514.1209   |
| 0.0100  | 0.0000  | 28216.6180  | 10607792.9780  |
| 0.0100  | 0.0050  | 44195.8758  | 11093202.5699  |
| 0.0100  | 0.0100  | 44424.3552  | 11106088.8117  |
| 0.0100  | 0.0150  | 44652.8347  | 11118975.0536  |
| 0.0100  | 0.0200  | 44881.3142  | 11131861.2955  |
| 0.0100  | 0.0250  | 45109.7936  | 11144747.5373  |
| 0.0100  | 0.0300  | 45338.2731  | 11157633.7792  |
| 0.0100  | 0.0350  | 45566.7526  | 11170520.0211  |
| 0.0100  | 0.0400  | 45795.2320  | 11183406.2629  |
| 0.0100  | 0.0450  | 46023.7115  | 11196292.5048  |
| 0.0100  | 0.0500  | 46252.1910  | 11209178.7467  |
| 0.0150  | -0.0500 | -2105.1354  | 9652816.1226   |
| 0.0150  | -0.0450 | -1863.1435  | 9670724.8540   |
| 0.0150  | -0.0400 | -1619.2098  | 9689184.6063   |
| 0.0150  | -0.0350 | -1371.4179  | 9708788.4211   |
| 0.0150  | -0.0300 | -1120.0801  | 9729259.0171   |
| 0.0150  | -0.0250 | -862.6256   | 9751197.9881   |
| 0.0150  | -0.0200 | -596.6836   | 9774856.3446   |
| 0.0150  | -0.0150 | -318.3500   | -37254.0417    |
| 0.0150  | -0.0100 | -20.2705    | 9827939.4221   |
| 0.0150  | -0.0050 | 312.6256    | 9855922.9556   |
| 0.0150  | 0.0000  | 31447.3176  | 10799213.0744  |
| 0.0150  | 0.0050  | 44424.3552  | 11194556.0609  |
| 0.0150  | 0.0100  | 44652.8347  | 11207442.3027  |
| 0.0150  | 0.0150  | 44881.3142  | 11220328.5446  |
| 0.0150  | 0.0200  | 45109.7936  | 11233214.7865  |
| 0.0150  | 0.0250  | 45338.2731  | 11246101.0283  |
| 0.0150  | 0.0300  | 45566.7526  | 11258987.2702  |
| 0.0150  | 0.0350  | 45795.2320  | 11271873.5121  |
| 0.0150  | 0.0400  | 46023.7115  | 11284759.7539  |
| 0.0150  | 0.0450  | 46252.1910  | 11297645.9958  |
| 0.0150  | 0.0500  | 46480.6704  | 11310532.2377  |
| 0.0200  | -0.0500 | -1840.9101  | 9767159.5198   |
| 0.0200  | -0.0450 | -1597.1223  | 9785315.3242   |
| 0.0200  | -0.0400 | -1351.0512  | 9804039.7535   |
| 0.0200  | -0.0350 | -1101.7134  | 9823547.0996   |
| 0.0200  | -0.0300 | -847.7923   | 9844069.8206   |
| 0.0200  | -0.0250 | -589.0878   | 9865391.4166   |
| 0.0200  | -0.0200 | -322.0000   | -38103.3333    |
| 0.0200  | -0.0150 | -44.4789    | 9911758.8587   |
| 0.0200  | -0.0100 | 249.4923    | 9936268.0381   |
| 0.0200  | -0.0050 | 570.0217    | 9960054.1549   |
| 0.0200  | 0.0000  | 34678.0173  | 10990633.1708  |
| 0.0200  | 0.0050  | 44652.8347  | 11295909.5519  |
| 0.0200  | 0.0100  | 44881.3142  | 11308795.7937  |
| 0.0200  | 0.0150  | 45109.7936  | 11321682.0356  |
| 0.0200  | 0.0200  | 45338.2731  | 11334568.2775  |
| 0.0200  | 0.0250  | 45566.7526  | 11347454.5193  |
| 0.0200  | 0.0300  | 45795.2320  | 11360340.7612  |
| 0.0200  | 0.0350  | 46023.7115  | 11373227.0031  |
| 0.0200  | 0.0400  | 46252.1910  | 11386113.2449  |
| 0.0200  | 0.0450  | 46480.6704  | 11398999.4868  |
| 0.0200  | 0.0500  | 46709.1499  | 11411885.7287  |
| 0.0250  | -0.0500 | -1581.0432  | 9879131.7295   |
| 0.0250  | -0.0450 | -1336.2345  | 9897247.5443   |
| 0.0250  | -0.0400 | -1089.0301  | 9915885.2237   |
| 0.0250  | -0.0350 | -838.5589   | 9935190.3197   |
| 0.0250  | -0.0300 | -584.1878   | 9955168.8324   |
| 0.0250  | -0.0250 | -324.1667   | -38614.5833    |
| 0.0250  | -0.0200 | -58.0622    | 9997420.4828   |
| 0.0250  | -0.0150 | 217.9589    | 10019552.4539  |
| 0.0250  | -0.0100 | 507.5676    | 10041835.1020  |
| 0.0250  | -0.0050 | 817.5679    | 10062889.8959  |
| 0.0250  | 0.0000  | 37908.7169  | 11182053.2671  |
| 0.0250  | 0.0050  | 44881.3142  | 11397263.0428  |
| 0.0250  | 0.0100  | 45109.7936  | 11410149.2847  |
| 0.0250  | 0.0150  | 45338.2731  | 11423035.5266  |
| 0.0250  | 0.0200  | 45566.7526  | 11435921.7684  |
| 0.0250  | 0.0250  | 45795.2320  | 11448808.0103  |
| 0.0250  | 0.0300  | 46023.7115  | 11461694.2522  |
| 0.0250  | 0.0350  | 46252.1910  | 11474580.4940  |
| 0.0250  | 0.0400  | 46480.6704  | 11487466.7359  |
| 0.0250  | 0.0450  | 46709.1499  | 11500352.9778  |
| 0.0250  | 0.0500  | 46937.6294  | 11513239.2196  |
| 0.0300  | -0.0500 | -1325.2512  | 9989122.7518   |
| 0.0300  | -0.0450 | -1079.0842  | 10007305.8374  |
| 0.0300  | -0.0400 | -831.4589   | 10025656.4855  |
| 0.0300  | -0.0350 | -580.5378   | 10044600.7899  |
| 0.0300  | -0.0300 | -325.6000   | -38955.6667    |
| 0.0300  | -0.0250 | -66.6289    | 10084046.7320  |
| 0.0300  | -0.0200 | 199.4589    | 10104632.6197  |
| 0.0300  | -0.0150 | 473.0009    | 10125341.3094  |
| 0.0300  | -0.0100 | 758.5845    | 10145958.0201  |
| 0.0300  | -0.0050 | 1059.8098   | 10165143.2515  |
| 0.0300  | 0.0000  | 41139.4166  | 11373473.3635  |
| 0.0300  | 0.0050  | 45109.7936  | 11498616.5338  |
| 0.0300  | 0.0100  | 45338.2731  | 11511502.7757  |
| 0.0300  | 0.0150  | 45566.7526  | 11524389.0176  |
| 0.0300  | 0.0200  | 45795.2320  | 11537275.2594  |
| 0.0300  | 0.0250  | 46023.7115  | 11550161.5013  |
| 0.0300  | 0.0300  | 46252.1910  | 11563047.7432  |
| 0.0300  | 0.0350  | 46480.6704  | 11575933.9850  |
| 0.0300  | 0.0400  | 46709.1499  | 11588820.2269  |
| 0.0300  | 0.0450  | 46937.6294  | 11601706.4688  |
| 0.0300  | 0.0500  | 47166.1088  | 11614592.7106  |
| 0.0350  | -0.0500 | -1072.2842  | 10097746.7115  |
| 0.0350  | -0.0450 | -826.4923   | 10115498.3180  |
| 0.0350  | -0.0400 | -578.2711   | 10133659.3723  |
| 0.0350  | -0.0350 | -326.5833   | -39191.1250    |
| 0.0350  | -0.0300 | -72.2997    | 10171265.2623  |
| 0.0350  | -0.0250 | 186.4923    | 10190567.2854  |
| 0.0350  | -0.0200 | 450.9634    | 10210176.2981  |
| 0.0350  | -0.0150 | 723.0845    | 10229914.0192  |
| 0.0350  | -0.0100 | 1004.1057   | 10249148.0735  |
| 0.0350  | -0.0050 | 1298.5435   | 10267073.5862  |
| 0.0350  | 0.0000  | 44370.1162  | 11564893.4599  |
| 0.0350  | 0.0050  | 45338.2731  | 11599970.0248  |
| 0.0350  | 0.0100  | 45566.7526  | 11612856.2667  |
| 0.0350  | 0.0150  | 45795.2320  | 11625742.5086  |
| 0.0350  | 0.0200  | 46023.7115  | 11638628.7504  |
| 0.0350  | 0.0250  | 46252.1910  | 11651514.9923  |
| 0.0350  | 0.0300  | 46480.6704  | 11664401.2342  |
| 0.0350  | 0.0350  | 46709.1499  | 11677287.4760  |
| 0.0350  | 0.0400  | 46937.6294  | 11690173.7179  |
| 0.0350  | 0.0450  | 47166.1088  | 11703059.9598  |
| 0.0350  | 0.0500  | 47394.5883  | 11715946.2016  |
| 0.0400  | -0.0500 | -822.6089   | 10205027.4421  |
| 0.0400  | -0.0450 | -575.8753   | 10222750.8611  |
| 0.0400  | -0.0400 | -327.3333   | -39371.3333    |
| 0.0400  | -0.0350 | -76.8330    | 10258715.5115  |
| 0.0400  | -0.0300 | 177.7089    | 10277249.9096  |
| 0.0400  | -0.0250 | 435.6926    | 10295912.0785  |
| 0.0400  | -0.0200 | 698.9845    | 10314776.1850  |
| 0.0400  | -0.0150 | 968.5890    | 10333553.0310  |
| 0.0400  | -0.0100 | 1246.7101   | 10351862.0854  |
| 0.0400  | -0.0050 | 1535.2521   | 10368833.9002  |
| 0.0400  | 0.0000  | 45338.2731  | 11688437.2740  |
| 0.0400  | 0.0050  | 45566.7526  | 11701323.5158  |
| 0.0400  | 0.0100  | 45795.2320  | 11714209.7577  |
| 0.0400  | 0.0150  | 46023.7115  | 11727095.9996  |
| 0.0400  | 0.0200  | 46252.1910  | 11739982.2414  |
| 0.0400  | 0.0250  | 46480.6704  | 11752868.4833  |
| 0.0400  | 0.0300  | 46709.1499  | 11765754.7252  |
| 0.0400  | 0.0350  | 46937.6294  | 11778640.9670  |
| 0.0400  | 0.0400  | 47166.1088  | 11791527.2089  |
| 0.0400  | 0.0450  | 47394.5883  | 11804413.4508  |
| 0.0400  | 0.0500  | 47623.0678  | 11817299.6926  |
| 0.0450  | -0.0500 | -574.8753   | 10311474.9435  |
| 0.0450  | -0.0450 | -327.9167   | -39511.7917    |
| 0.0450  | -0.0400 | -79.7289    | 10346526.4793  |
| 0.0450  | -0.0350 | 170.8256    | 10364275.9504  |
| 0.0450  | -0.0300 | 425.1259    | 10382389.6193  |
| 0.0450  | -0.0250 | 682.0845    | 10400458.0174  |
| 0.0450  | -0.0200 | 944.0848    | 10418666.5614  |
| 0.0450  | -0.0150 | 1211.9435   | 10436729.9178  |
| 0.0450  | -0.0100 | 1486.2479   | 10454172.4305  |
| 0.0450  | -0.0050 | 3510.7532   | 10522689.3431  |
| 0.0450  | 0.0000  | 45566.7526  | 11789790.7649  |
| 0.0450  | 0.0050  | 45795.2320  | 11802677.0068  |
| 0.0450  | 0.0100  | 46023.7115  | 11815563.2487  |
| 0.0450  | 0.0150  | 46252.1910  | 11828449.4905  |
| 0.0450  | 0.0200  | 46480.6704  | 11841335.7324  |
| 0.0450  | 0.0250  | 46709.1499  | 11854221.9743  |
| 0.0450  | 0.0300  | 46937.6294  | 11867108.2161  |
| 0.0450  | 0.0350  | 47166.1088  | 11879994.4580  |
| 0.0450  | 0.0400  | 47394.5883  | 11892880.6999  |
| 0.0450  | 0.0450  | 47623.0678  | 11905766.9417  |
| 0.0450  | 0.0500  | 47851.5472  | 11918653.1836  |
| 0.0500  | -0.0500 | -328.3333   | -39612.5000    |
| 0.0500  | -0.0450 | -82.8330    | 10434279.0514  |
| 0.0500  | -0.0400 | 165.3756    | 10451576.0745  |
| 0.0500  | -0.0350 | 416.1801    | 10469102.2539  |
| 0.0500  | -0.0300 | 669.2512    | 10486665.0166  |
| 0.0500  | -0.0250 | 925.9390    | 10504357.7376  |
| 0.0500  | -0.0200 | 1186.5601   | 10521993.5420  |
| 0.0500  | -0.0150 | 1452.5479   | 10539443.6797  |
| 0.0500  | -0.0100 | 1724.0357   | 10556261.4840  |
| 0.0500  | -0.0050 | 6746.5779   | 10714309.1270  |
| 0.0500  | 0.0000  | 45795.2320  | 11891144.2559  |
| 0.0500  | 0.0050  | 46023.7115  | 11904030.4978  |
| 0.0500  | 0.0100  | 46252.1910  | 11916916.7397  |
| 0.0500  | 0.0150  | 46480.6704  | 11929802.9815  |
| 0.0500  | 0.0200  | 46709.1499  | 11942689.2234  |
| 0.0500  | 0.0250  | 46937.6294  | 11955575.4653  |
| 0.0500  | 0.0300  | 47166.1088  | 11968461.7071  |
| 0.0500  | 0.0350  | 47394.5883  | 11981347.9490  |
| 0.0500  | 0.0400  | 47623.0678  | 11994234.1909  |
| 0.0500  | 0.0450  | 47851.5472  | 12007120.4327  |
| 0.0500  | 0.0500  | 48080.0267  | 12020006.6746  |

我可以毫无问题地在 Excel (2019) 中打开此文件。为了检查我的值,我尝试添加一个显示 3D 点的图表。但我在 Excel 中找不到可直接使用的图表类型。因此,我将我的值从 x|y|值列表(步骤 1.)转换为 ax/y 值网格(步骤 2.):

Excel 步骤 1、2 和 3 以及图表

Excel 步骤 1、2 和 3 以及图表

它可以工作,我可以创建一个图表 (3.)。但我必须手动进行 1->2 转换。

有没有使用 Excel 或其他替代方法的简单方法?我只需要一个好的 3D 可视化用于调试目的。

提前感谢您的建议!

答案1

假设“1”表位于 AD 列,G4:N4 和 H5:H28 是表“2”的“x”和“y”标签。将此公式放在第一个值单元格 (H5),然后拖到表格末尾:

=INDEX($C:$C,MATCH(1,INDEX(($G5=$A:$A)*(H$4=$B:$B),0,1),0))

參考文獻:多条件索引匹配

希望能帮助到你。 ( :

相关内容