Fill area beneath a scatter plot

[JZip]

Hi,
I'm producing scatter plots showing elevation change along state park
trails. It must be done on a scatter plot as the distances at which the data
was taken are not uniform...unless someone has another method that I haven't
thought of yet. I would like to fill the area beneath the plot to better
represent a cross section of the trail. In time we may elect to code the
fill area to represent soil types, geology, or surface firmness.
How can I fill the area beneath a scatter plot??
Thx in advance,
Jeff

 

[Barb Reinhardt]

Have you tried the Area Plot instead of the scatter plot?

 

[JZip]

Barb,
An area chart won't do it as the distances the data was taken at are
irregular. Unless I'm missing a way to have them behave the way I need.
Open to suggestions....
Thx.

Here's the data...plotting distance on the x axis and z(feet) on the y
distance z (feet)
0.00000 0
0.00789 3.28084
0.01531 6.56168
0.02459 9.84252
0.03109 13.12336
0.03665 16.4042
0.04129 19.68504
0.04779 22.96588
0.05475 26.24672
0.06032 29.52756
0.06681 32.8084
0.07377 36.08924
0.08073 39.37008
0.08491 42.65092
0.09233 45.93176
0.09929 49.2126
0.10671 52.49344
0.11367 55.77428
0.12109 59.05512
0.12805 62.33596
0.13641 65.6168
0.14476 68.89764
0.15172 72.17848
0.15868 75.45932
0.16563 78.74016
0.17027 82.021
0.17816 85.30184
0.18466 88.58268
0.19022 91.86352
0.19347 95.14436
0.19950 98.4252
0.20693 101.70604
0.21481 104.98688
0.22224 108.26772
0.23245 111.54856
0.23894 114.8294
0.24497 118.11024
0.25100 121.39108
0.25750 124.67192
0.26353 127.95276
0.27003 131.2336
0.27606 134.51444
0.28255 137.79528
0.29137 141.07612
0.30250 144.35696
0.30946 147.6378
0.31410 150.91864
0.32245 154.19948
0.33313 157.48032
0.34008 160.76116
0.34704 164.042
0.35632 167.32284
0.36143 170.60368
0.36931 173.88452
0.37535 177.16536
0.38184 180.4462
0.38834 183.72704
0.39437 187.00788
0.40086 190.28872
0.41014 193.56956
0.41664 196.8504
0.42313 200.13124
0.43056 203.41208
0.44030 206.69292
0.44680 209.97376
0.45561 213.2546
0.46582 216.53544
0.46767 219.81628
0.47603 223.09712
0.48391 226.37796
0.49412 229.6588
0.50154 232.93964
0.50850 236.22048
0.51546 239.50132
0.52103 242.78216
0.52845 246.063
0.53309 249.34384
0.53959 252.62468
0.54608 255.90552
0.55212 259.18636
0.55861 262.4672
0.56464 265.74804
0.57114 269.02888
0.57717 272.30972
0.58135 275.59056
0.58877 278.8714
0.59619 282.15224
0.60408 285.43308
0.61150 288.71392
0.61800 291.99476
0.62449 295.2756
0.63099 298.55644
0.63748 301.83728
0.64491 305.11812
0.65187 308.39896
0.65929 311.6798
0.66996 314.96064
0.67692 318.24148
0.68342 321.52232
0.69038 324.80316
0.69687 328.084
0.70383 331.36484
0.71079 334.64568
0.71821 337.92652
0.72564 341.20736
0.73028 344.4882
0.73724 347.76904
0.74373 351.04988
0.75069 354.33072
0.75765 357.61156
0.76415 360.8924
0.77018 364.17324
0.77807 367.45408
0.78410 370.73492
0.79059 374.01576
0.79662 377.2966
0.80266 380.57744
0.80915 383.85828
0.81518 387.13912
0.82168 390.41996
0.82771 393.7008
0.83374 396.98164
0.84024 400.26248
0.84627 403.54332
0.85276 406.82416
0.85880 410.105
0.86715 413.38584
0.87643 416.66668
0.88478 419.94752
0.89359 423.22836
0.90055 426.5092
0.90705 429.79004
0.91308 433.07088
0.91957 436.35172
0.92607 439.63256
0.92932 442.9134
0.93674 446.19424
0.94231 449.47508
0.95112 452.75592
0.95948 456.03676
0.97107 459.3176
0.98128 462.59844
0.98685 465.87928
0.99288 469.16012
0.99938 472.44096
1.00541 475.7218
1.01190 479.00264
1.01840 482.28348
1.02489 485.56432
1.02861 488.84516
1.03556 492.126
1.04252 495.40684
1.04948 498.68768
1.05644 501.96852
1.06340 505.24936
1.07175 508.5302
1.07918 511.81104
1.08660 515.09188
1.09634 518.37272
1.10516 521.65356
1.11444 524.9344
1.12186 528.21524
1.12882 531.49608
1.13578 534.77692
1.14135 538.05776
1.14831 541.3386
1.15480 544.61944
1.16176 547.90028
1.16965 551.18112
1.17800 554.46196
1.18311 557.7428
1.18774 561.02364
1.19378 564.30448
1.20027 567.58532
1.20306 570.86616
1.20955 574.147
1.21651 577.42784
1.22254 580.70868
1.22904 583.98952
1.23507 587.27036
1.24110 590.5512
1.24574 593.83204
1.25177 597.11288
1.25827 600.39372
1.26476 603.67456
1.27079 606.9554
1.27729 610.23624
1.28379 613.51708
1.28982 616.79792
1.29817 620.07876
1.30513 623.3596
1.31394 626.64044
1.31997 629.92128
1.32647 633.20212
1.33250 636.48296
1.33668 639.7638
1.34503 643.04464
1.35245 646.32548
1.36034 649.60632
1.36823 652.88716
1.37751 656.168
1.38354 659.44884
1.39003 662.72968
1.39606 666.01052
1.40256 669.29136
1.40859 672.5722
1.41509 675.85304
1.41973 679.13388
1.42622 682.41472
1.43225 685.69556
1.43828 688.9764
1.44478 692.25724
1.45081 695.53808
1.45731 698.81892
1.46334 702.09976
1.46937 705.3806
1.47587 708.66144
1.48097 711.94228
1.48839 715.22312
1.49535 718.50396
1.50231 721.7848
1.50881 725.06564
1.51530 728.34648
1.52180 731.62732
1.52829 734.90816
1.53479 738.189
1.54128 741.46984
1.54453 744.75068
1.55149 748.03152
1.55845 751.31236
1.56541 754.5932
1.57237 757.87404
1.57887 761.15488
1.58536 764.43572
1.59093 767.71656
1.60206 770.9974
1.60856 774.27824
1.61505 777.55908
1.62201 780.83992
1.62851 784.12076
1.63269 787.4016
1.63918 790.68244
1.64289 793.96328
1.64892 797.24412
1.65542 800.52496
1.66145 803.8058
1.66470 807.08664
1.67259 810.36748
1.68001 813.64832
1.68650 816.92916
1.69393 820.21
1.69996 823.49084
1.70646 826.77168
1.71017 830.05252
1.71620 833.33336
1.72362 836.6142
1.73105 839.89504
1.73893 843.17588
1.74543 846.45672
1.75192 849.73756
1.75842 853.0184
1.76491 856.29924
1.77373 859.58008
1.78069 862.86092
1.78811 866.14176
1.79461 869.4226
1.80018 872.70344
1.80899 875.98428
1.81827 879.26512
1.82709 882.54596
1.83497 885.8268
1.84147 889.10764
1.84936 892.38848
1.85585 895.66932
1.86003 898.95016
1.86699 902.231
1.87070 905.51184
1.87905 908.79268
1.88740 912.07352
1.89250 915.35436
1.89993 918.6352
1.90782 921.91604
1.91524 925.19688
1.91988 928.47772
1.92637 931.75856
1.93287 935.0394
1.93890 938.32024
1.94540 941.60108
1.95189 944.88192
1.95792 948.16276
1.96442 951.4436
1.97045 954.72444
1.97695 958.00528
1.98344 961.28612
1.99040 964.56696
1.99643 967.8478
2.00525 971.12864
2.01545 974.40948
2.02195 977.69032
2.02659 980.97116
2.03494 984.252
2.04329 987.53284
2.04979 990.81368
2.05814 994.09452
2.06417 997.37536
2.07206 1000.6562
2.08134 1003.93704
2.08737 1007.21788
2.09386 1010.49872
2.10036 1013.77956
2.10639 1017.0604
2.11289 1020.34124
2.11613 1023.62208
2.12309 1026.90292
2.13005 1030.18376
2.13655 1033.4646
2.14351 1036.74544
2.15047 1040.02628
2.15743 1043.30712
2.16392 1046.58796
2.16995 1049.8688
2.17645 1053.14964
2.18248 1056.43048
2.18898 1059.71132
2.19315 1062.99216
2.19965 1066.273
2.20336 1069.55384
2.21171 1072.83468
2.22006 1076.11552
2.22795 1079.39636
2.23862 1082.6772
2.24651 1085.95804
2.25440 1089.23888
2.26275 1092.51972
2.27063 1095.80056
2.27667 1099.0814
2.28362 1102.36224
2.29290 1105.64308
2.29940 1108.92392
2.30775 1112.20476
2.31749 1115.4856
2.32492 1118.76644
2.33234 1122.04728
2.33976 1125.32812
2.34812 1128.60896
2.35600 1131.8898
2.36296 1135.17064
2.37178 1138.45148
2.37874 1141.73232
2.38662 1145.01316
2.39451 1148.294
2.40194 1151.57484
2.40611 1154.85568
2.41261 1158.13652
2.41864 1161.41736
2.42513 1164.6982
2.43163 1167.97904
2.43534 1171.25988
2.44184 1174.54072
2.45065 1177.82156
2.45668 1181.1024
2.46318 1184.38324
2.47014 1187.66408
2.47710 1190.94492
2.48406 1194.22576
2.49148 1197.5066
2.49798 1200.78744
2.50494 1204.06828
2.50818 1207.34912
2.51421 1210.62996
2.52210 1213.9108
2.52860 1217.19164
2.53463 1220.47248
2.54112 1223.75332
2.54762 1227.03416
2.55412 1230.315
2.56154 1233.59584
2.56757 1236.87668
2.57360 1240.15752
2.58010 1243.43836
2.58613 1246.7192
2.59262 1250.00004
2.60098 1253.28088
2.60515 1256.56172
2.61165 1259.84256
2.61768 1263.1234
2.62557 1266.40424
2.63252 1269.68508
2.63948 1272.96592
2.64691 1276.24676
2.65387 1279.5276
2.65804 1282.80844
2.66593 1286.08928
2.67335 1289.37012
2.68449 1292.65096
2.69238 1295.9318
2.70026 1299.21264
2.70815 1302.49348
2.71511 1305.77432
2.72207 1309.05516
2.73135 1312.336
2.73784 1315.61684
2.74434 1318.89768
2.75084 1322.17852
2.75687 1325.45936
2.76336 1328.7402
2.76939 1332.02104
2.77589 1335.30188
2.78192 1338.58272
2.78842 1341.86356
2.79491 1345.1444
2.80094 1348.42524
2.80698 1351.70608
2.81347 1354.98692
2.81950 1358.26776
2.82600 1361.5486
2.83435 1364.82944
2.84084 1368.11028
2.84688 1371.39112
2.85337 1374.67196
2.85940 1377.9528
2.86543 1381.23364
2.87193 1384.51448
2.87796 1387.79532
2.88446 1391.07616
2.89049 1394.357
2.89652 1397.63784
2.90302 1400.91868
2.90905 1404.19952
2.91554 1407.48036
2.92157 1410.7612
2.92761 1414.04204
2.93132 1417.32288
2.93781 1420.60372
2.94384 1423.88456
2.95034 1427.1654
2.95637 1430.44624
2.96287 1433.72708
2.96890 1437.00792
2.97261 1440.28876
2.97911 1443.5696
2.98560 1446.85044
2.99210 1450.13128
2.99859 1453.41212
3.00555 1456.69296
3.01205 1459.9738
3.01854 1463.25464
3.02504 1466.53548
3.03153 1469.81632
3.03803 1473.09716
3.04499 1476.378
3.05148 1479.65884
3.05798 1482.93968
3.06447 1486.22052
3.06865 1489.50136
3.07468 1492.7822
3.08025 1496.06304
3.08674 1499.34388
3.09324 1502.62472
3.10020 1505.90556
3.10762 1509.1864
3.11412 1512.46724
3.12061 1515.74808
3.12711 1519.02892
3.13360 1522.30976
3.13871 1525.5906
3.14520 1528.87144
3.15170 1532.15228
3.15866 1535.43312
3.16515 1538.71396
3.17119 1541.9948
3.17861 1545.27564
3.18603 1548.55648
3.19346 1551.83732
3.20088 1555.11816
3.20830 1558.399
3.21573 1561.67984
3.21990 1564.96068
3.22733 1568.24152
3.23428 1571.52236
3.24124 1574.8032
3.24867 1578.08404
3.25702 1581.36488
3.26491 1584.64572
3.27233 1587.92656
3.28022 1591.2074
3.28764 1594.48824
3.29414 1597.76908
3.30295 1601.04992
3.31177 1604.33076
3.32058 1607.6116
3.32893 1610.89244
3.33589 1614.17328
3.34378 1617.45412
3.35167 1620.73496
3.35955 1624.0158
3.36744 1627.29664
3.37533 1630.57748
3.38322 1633.85832
3.39110 1637.13916
3.39899 1640.42
3.40502 1643.70084
3.41384 1646.98168
3.42219 1650.26252
3.42776 1653.54336
3.43518 1656.8242
3.44307 1660.10504
3.45374 1663.38588
3.46023 1666.66672
3.46673 1669.94756
3.47323 1673.2284
3.47647 1676.50924
3.48297 1679.79008
3.48900 1683.07092
3.49596 1686.35176
3.50199 1689.6326
3.50849 1692.91344
3.51220 1696.19428
3.51869 1699.47512
3.52519 1702.75596
3.53215 1706.0368
3.53864 1709.31764
3.54468 1712.59848
3.55210 1715.87932
3.55999 1719.16016
3.56787 1722.441
3.57344 1725.72184
3.58133 1729.00268
3.58968 1732.28352
3.59757 1735.56436
3.60267 1738.8452
3.60963 1742.12604
3.61659 1745.40688
3.62726 1748.68772
3.63376 1751.96856
3.64025 1755.2494
3.64582 1758.53024
3.65185 1761.81108
3.65835 1765.09192
3.66438 1768.37276
3.67087 1771.6536
3.67691 1774.93444
3.68340 1778.21528
3.68943 1781.49612
3.69593 1784.77696
3.70196 1788.0578
3.70845 1791.33864
3.71449 1794.61948
3.72098 1797.90032
3.72701 1801.18116
3.73351 1804.462
3.73954 1807.74284
3.74557 1811.02368
3.75207 1814.30452
3.75763 1817.58536
3.76413 1820.8662
3.77063 1824.14704
3.77991 1827.42788
3.78686 1830.70872
3.79382 1833.98956
3.80078 1837.2704
3.80867 1840.55124
3.81563 1843.83208
3.82259 1847.11292
3.82955 1850.39376
3.83326 1853.6746
3.83929 1856.95544
3.84579 1860.23628
3.85228 1863.51712
3.85831 1866.79796
3.86388 1870.0788
3.86991 1873.35964
3.87363 1876.64048
3.88058 1879.92132
3.88662 1883.20216
3.89311 1886.483
3.89682 1889.76384
3.90425 1893.04468
3.91167 1896.32552
3.91956 1899.60636
3.92698 1902.8872
3.93255 1906.16804
3.94090 1909.44888
3.94925 1912.72972
3.95760 1916.01056
3.96178 1919.2914
3.96874 1922.57224
3.97570 1925.85308
3.98266 1929.13392
3.98915 1932.41476
3.99611 1935.6956
4.00307 1938.97644
4.00957 1942.25728
4.01792 1945.53812
4.02581 1948.81896
4.03416 1952.0998
4.04622 1955.38064
4.05318 1958.66148
4.06385 1961.94232
4.07035 1965.22316
4.07359 1968.504
4.08102 1971.78484
4.08844 1975.06568
4.09586 1978.34652
4.10561 1981.62736
4.11303 1984.9082
4.12092 1988.18904
4.12834 1991.46988
4.13623 1994.75072
4.14412 1998.03156
4.15061 2001.3124
4.15757 2004.59324
4.16453 2007.87408
4.17288 2011.15492
4.18170 2014.43576
4.19005 2017.7166
4.19469 2020.99744
4.20165 2024.27828
4.20861 2027.55912
4.21557 2030.83996
4.22206 2034.1208
4.22902 2037.40164
4.23459 2040.68248
4.24201 2043.96332
4.25176 2047.24416
4.25779 2050.525
4.26660 2053.80584
4.27356 2057.08668
4.28052 2060.36752
4.28377 2063.64836
4.29258 2066.9292
4.30186 2070.21004
4.30929 2073.49088
4.31717 2076.77172
4.32460 2080.05256
4.33202 2083.3334
4.33805 2086.61424
4.34455 2089.89508
4.35058 2093.17592
4.35707 2096.45676
4.36032 2099.7376
4.36682 2103.01844
4.37331 2106.29928
4.37934 2109.58012
4.38584 2112.86096
4.39234 2116.1418
4.39558 2119.42264
4.40208 2122.70348
4.40950 2125.98432
4.41693 2129.26516
4.42389 2132.546
4.43038 2135.82684
4.43548 2139.10768
4.44152 2142.38852
4.44848 2145.66936
4.45543 2148.9502
4.46332 2152.23104
4.47167 2155.51188
4.47956 2158.79272
4.48884 2162.07356
4.49534 2165.3544
4.50230 2168.63524
4.50879 2171.91608
4.51297 2175.19692
4.51946 2178.47776
4.52874 2181.7586
4.53524 2185.03944
4.54034 2188.32028
4.54916 2191.60112
4.55565 2194.88196
4.56261 2198.1628
4.57282 2201.44364
4.58117 2204.72448
4.58766 2208.00532
4.59416 2211.28616
4.60019 2214.567
4.60808 2217.84784
4.61457 2221.12868
4.62246 2224.40952
4.62988 2227.69036
4.63963 2230.9712

 

[Barb Reinhardt]

http://www.peltiertech.com/Excel/Charts/XYAreaChart.html

 

[jzip]

Barb,
Thanks! That did it, although a little pecularly
Jeff