Data S&P 500 Data DateOpenHighLowClose 10/3/071539.741545.841536.341539.59 10/4/071542.631544.021537.631542.84 10/5/071550.511561.911543.841557.59...

Create a line chart for the closing prices for all years, and a stock chart for the high/low/close prices for August 2013 in the Excel file S&P500


Data S&P 500 Data DateOpenHighLowClose 10/3/071539.741545.841536.341539.59 10/4/071542.631544.021537.631542.84 10/5/071550.511561.911543.841557.59 10/8/071553.691556.511549.001552.58 10/9/071556.291565.271551.811565.15 10/10/071561.651565.361555.461562.47 10/11/071570.071576.091546.721554.41 10/12/071556.501563.031554.091561.80 10/15/071563.211564.741540.811548.71 10/16/071545.851547.811536.291538.53 10/17/071553.141550.661526.011541.24 10/18/071534.511542.791531.761540.08 10/19/071531.121540.001500.261500.63 10/22/071487.211508.061490.401506.33 10/23/071515.651520.011503.611519.59 10/24/071511.161517.231489.561515.88 10/25/071517.911523.241500.461514.40 10/26/071533.781535.531520.181535.28 10/29/071540.111544.671536.431540.98 10/30/071533.851539.421529.551531.02 10/31/071538.671552.761529.401549.38 11/1/071531.611545.791506.661508.44 11/2/071513.661513.151492.531509.65 11/5/071494.211510.841489.951502.17 11/6/071509.491520.771499.071520.27 11/7/071503.911515.461475.041475.62 11/8/071478.911482.501450.311474.77 11/9/071454.751474.091448.511453.70 11/12/071448.491464.941438.531439.18 11/13/071450.851481.371441.351481.05 11/14/071490.311492.141466.471470.58 11/15/071463.901472.671443.491451.15 11/16/071462.181462.181443.991458.74 11/19/071451.381456.701430.421433.27 11/20/071434.751452.641419.281439.70 11/21/071427.001436.401415.641416.77 11/23/071427.031440.861417.621440.70 11/26/071439.071446.091406.101407.22 11/27/071412.601429.491407.431428.23 11/28/071441.561471.621432.951469.02 11/29/071463.481473.811458.361469.72 11/30/071488.741488.741469.721481.14 12/3/071478.221481.161470.081472.42 12/4/071461.851471.341460.661462.79 12/5/071474.101485.851462.061485.01 12/6/071481.891508.021482.191507.34 12/7/071510.621510.411502.711504.66 12/10/071507.331518.271504.961515.96 12/11/071518.431523.571475.991477.65 12/12/071508.191511.961468.231486.59 12/13/071476.951489.401469.211488.41 12/14/071475.381488.391467.871467.95 12/17/071467.951467.951445.461445.90 12/18/071455.911460.161435.651454.98 12/19/071453.671464.401445.491453.00 12/20/071461.531461.531447.221460.12 12/21/071474.951485.401463.191484.46 12/24/071486.701497.631484.551496.45 12/26/071491.181498.851488.201497.66 12/27/071491.421495.051475.861476.37 12/28/071485.901487.901471.741478.49 12/31/071470.591475.831465.131468.36 1/2/081468.301471.771442.071447.16 1/3/081450.141456.801443.731447.16 1/4/081434.721444.011411.191411.63 1/7/081417.971423.871403.451416.18 1/8/081422.151430.281388.301390.19 1/9/081390.431409.191378.701409.13 1/10/081397.541429.071395.301420.33 1/11/081406.911419.911394.831401.02 1/14/081412.871417.891402.911416.25 1/15/081397.731411.881380.601380.95 1/16/081373.271391.991364.271373.20 1/17/081377.271377.721330.671333.25 1/18/081333.941350.281312.511325.19 1/22/081266.791322.091274.291310.50 1/23/081277.561339.091270.051338.60 1/24/081344.921355.151334.311352.07 1/25/081368.841368.561327.501330.61 1/28/081334.171353.971322.261353.97 1/29/081363.331364.931350.191362.30 1/30/081356.601385.861352.951355.81 1/31/081334.921385.621334.081378.55 2/1/081381.721396.021375.931395.42 2/4/081395.271395.381379.691380.82 2/5/081357.261380.281336.641336.64 2/6/081346.801351.961324.341326.45 2/7/081321.091347.161316.751336.91 2/8/081331.341341.221321.061331.29 2/11/081331.231341.401320.321339.13 2/12/081346.931362.101339.361348.86 2/13/081360.011369.231350.781367.21 2/14/081368.161368.161347.311348.86 2/15/081347.201350.001338.131349.99 2/19/081366.841367.281345.051348.78 2/20/081338.561363.711336.551360.03 2/21/081364.301367.941339.341342.53 2/22/081346.801354.301327.041353.11 2/25/081353.131374.361346.031371.80 2/26/081364.311387.341363.291381.29 2/27/081372.151388.341372.001380.02 2/28/081378.161378.161363.161367.68 2/29/081354.121364.071325.421330.63 3/3/081329.681335.131320.041331.34 3/4/081320.751331.031307.391326.75 3/5/081330.321344.191320.221333.70 3/6/081329.231332.201303.421304.34 3/7/081294.661313.241282.431293.37 3/10/081293.681295.011272.661273.37 3/11/081301.401320.651274.401320.65 3/12/081322.231333.261307.861308.77 3/13/081291.341321.681282.111315.48 3/14/081319.781321.471274.861288.14 3/17/081331.341287.501256.981276.60 3/18/081302.221330.741277.161330.74 3/19/081334.631341.511298.421298.42 3/20/081302.641330.671295.221329.51 3/24/081333.661359.681330.291349.88 3/25/081351.421357.471341.211352.99 3/26/081343.931352.451336.411341.13 3/27/081345.621345.621325.661325.76 3/28/081329.571334.871312.951315.22 3/31/081314.421328.521312.811322.70 4/1/081340.941370.181326.411370.18 4/2/081373.151377.951361.551367.53 4/3/081359.711375.661358.681369.31 4/4/081370.561380.911362.831370.40 4/7/081381.191386.741369.021372.54 4/8/081362.611370.161360.621365.54 4/9/081365.431368.391349.971354.49 4/10/081355.211367.241350.111360.55 4/11/081343.581357.981331.211332.83 4/14/081331.831335.641326.161328.32 4/15/081337.591337.721324.351334.43 4/16/081346.431365.491337.021364.71 4/17/081360.181368.601357.251365.56 4/18/081391.121395.901369.001390.33 4/21/081382.691390.231379.251388.17 4/22/081382.471386.431369.841375.94 4/23/081379.711387.871372.241379.93 4/24/081382.141397.721371.091388.82 4/25/081395.181399.111379.981397.84 4/28/081398.441402.901394.401396.37 4/29/081393.181397.001386.701390.94 4/30/081393.891404.571384.251385.59 5/1/081384.231410.071383.071409.34 5/2/081409.161422.721406.251413.90 5/5/081410.831415.701404.371407.49 5/6/081401.491421.571397.101418.26 5/7/081417.531419.541391.161392.57 5/8/081397.751402.351389.391397.68 5/9/081385.111394.901384.111388.28 5/12/081390.401404.061386.201403.58 5/13/081407.071406.301396.261403.04 5/14/081409.451420.191405.651408.66 5/15/081408.361424.401406.871423.57 5/16/081425.701425.821414.351425.35 5/19/081425.741440.241421.631426.63 5/20/081419.931424.491409.091413.40 5/21/081416.161419.121388.811390.71 5/22/081390.831399.071390.231394.35 5/23/081389.241392.201373.721375.93 5/27/081374.981387.401373.071385.35 5/28/081388.381391.251378.161390.84 5/29/081387.501406.321388.591398.26 5/30/081401.861404.461398.081400.38 6/2/081395.741399.621377.791385.67 6/3/081389.881393.121370.121377.65 6/4/081373.971388.181371.741377.20 6/5/081382.331404.051377.481404.05 6/6/081419.931400.061359.901360.68 6/9/081366.181370.631350.621361.76 6/10/081351.931366.841351.561358.44 6/11/081355.251357.091335.471335.49 6/12/081342.561353.031331.291339.87 6/13/081347.731360.031341.711360.03 6/16/081351.741364.701352.071360.14 6/17/081365.561366.591350.541350.93 6/18/081341.491349.591333.401337.81 6/19/081336.691347.661330.501342.83 6/20/081339.281341.021314.461317.93 6/23/081322.351323.781315.311318.00 6/24/081311.621326.021304.421314.29 6/25/081319.241335.631314.541321.97 6/26/081307.491316.291283.151283.15 6/27/081284.441289.451272.001278.38 6/30/081280.331290.311274.861280.00 7/1/081266.791285.311260.681284.91 7/2/081290.111292.171261.511261.52 7/3/081269.931271.481252.011262.90 7/7/081265.671273.951240.681252.31 7/8/081250.671274.171242.841273.70 7/9/081274.691277.361244.691244.69 7/10/081245.711257.651236.761253.39 7/11/081238.551257.271225.351239.49 7/14/081253.501253.501225.011228.30 7/15/081215.521234.351200.441214.91 7/16/081214.501245.521211.391245.36 7/17/081251.391262.311241.491260.32 7/18/081262.231262.231251.811260.68 7/21/081264.671267.741255.701260.00 7/22/081251.451277.421248.831277.00 7/23/081280.281291.171276.061282.19 7/24/081282.951283.221251.481252.54 7/25/081259.731263.331251.751257.76 7/28/081254.671260.091234.371234.37 7/29/081240.101263.201236.381263.20 7/30/081269.561284.331264.521284.26 7/31/081271.661284.931265.971267.38 8/1/081270.521270.521254.541260.31 8/4/081258.071260.491247.451249.01 8/5/081254.871284.881254.671284.88 8/6/081279.881291.671276.001289.19 8/7/081279.571286.511264.291266.07 8/8/081263.681297.851262.111296.32 8/11/081293.731313.151291.411305.32 8/12/081300.681304.791285.641289.59 8/13/081285.221294.031274.861285.83 8/14/081274.991300.111276.841292.93 8/15/081294.491302.051290.741298.20 8/18/081299.981300.221274.511278.60 8/19/081270.181276.651263.111266.69 8/20/081271.441276.011261.161274.54 8/21/081266.141281.401265.221277.72 8/22/081282.921293.091277.591292.20 8/25/081284.711290.471264.871266.84 8/26/081267.151275.651263.211271.51 8/27/081272.581285.051270.031281.66 8/28/081288.001300.681283.791300.68 8/29/081293.821297.591282.741282.83 9/2/081298.331303.041272.201277.58 9/3/081275.031280.601265.591274.98 9/4/081266.061271.801232.831236.83 9/5/081228.921244.941217.231242.31 9/8/081274.421274.421247.121267.79 9/9/081265.411268.661224.511224.51 9/10/081235.971243.901221.601232.04 9/11/081214.941249.981211.541249.05 9/12/081238.771255.091233.811251.70 9/15/081213.161250.921192.701192.70 9/16/081169.281214.841169.281213.59 9/17/081189.891210.341155.881156.39 9/18/081178.201211.141133.501206.51 9/19/081265.121265.121213.111255.08 9/22/081245.871255.371205.611207.09 9/23/081210.441221.151187.061188.22 9/24/081187.461197.411179.791185.87 9/25/081187.871220.031187.871209.18 9/26/081187.541215.771187.541213.01 9/29/081188.461209.071106.391106.39 9/30/081135.001168.031113.781166.36 10/1/081154.701167.031140.771161.06 10/2/081150.851160.641111.431114.28 10/3/081128.351153.821098.141099.23 10/6/081065.591097.561007.971056.89 10/7/081068.331072.91996.23996.23 10/8/08966.161021.06970.97984.94 10/9/08998.221005.25909.19909.92 10/10/08866.33936.36839.80899.22 10/13/08944.621006.93912.751003.35 10/14/081049.691044.31972.07998.01 10/15/08975.22994.60903.99907.84 10/16/08912.04947.71865.83946.43 10/17/08922.71984.64918.74940.55 10/20/08954.92985.40943.51985.40 10/21/08971.04985.44952.47955.05 10/22/08931.62951.67875.81896.78 10/23/08904.11922.83858.44908.11 10/24/08852.85896.30852.85876.77 10/27/08860.23893.78846.75848.92 10/28/08873.12940.51845.27940.51 10/29/08937.26969.97922.26930.09 10/30/08958.09963.23928.50954.09 10/31/08952.83984.38944.59968.75 11/3/08968.24975.57958.82966.30 11/4/08988.881007.51971.311005.75 11/5/08991.231001.84949.86952.77 11/6/08942.74952.40899.73904.88 11/7/08914.67931.46906.90930.99 11/10/08949.74951.95907.47919.21 11/11/08905.50917.15884.90898.95 11/12/08880.15893.39850.48852.30 11/13/08857.06913.01818.69911.29 11/14/08891.18916.88869.88873.29 11/17/08862.09882.29848.98850.75 11/18/08849.31865.90826.84859.12 11/19/08857.68864.57806.18806.58 11/20/08795.69820.52747.78752.44 11/21/08763.45801.20741.02800.03 11/24/08818.21865.60801.20851.81 11/25/08868.48868.94834.99857.39 11/26/08840.68887.68841.37887.68 11/28/08883.43896.25881.21896.24 12/1/08870.24888.61815.69816.21 12/2/08831.73850.54817.94848.81 12/3/08827.93873.12827.60870.74 12/4/08855.96875.60833.60845.22 12/5/08835.12879.42818.41876.07 12/8/08898.02918.57882.71909.70 12/9/08896.70916.26885.38888.67 12/10/08897.20908.27885.45899.24 12/11/08889.54904.63868.73873.59 12/12/08848.74883.24851.35879.73 12/15/08883.16884.63857.72868.57 12/16/08875.40914.66871.53913.18 12/17/08900.54918.85895.94904.42 12/18/08907.96911.02877.44885.28 12/19/08889.74905.47883.02887.88 12/22/08888.33887.37857.09871.63 12/23/08879.80880.44860.10863.16 12/24/08863.73869.79861.44868.15 12/26/08872.03873.74866.52872.80 12/29/08873.76873.76857.07869.42 12/30/08873.87891.12870.58890.64 12/31/08890.22910.32889.67903.25 1/2/09904.61934.73899.73931.80 1/5/09549.33936.63919.53927.45 1/6/09937.33943.85927.28934.70 1/7/09917.87927.45902.37906.65 1/8/09901.25910.00896.81909.73 1/9/09910.92911.93888.31890.35 1/12/09888.53890.40864.32870.26 1/13/09867.39877.02862.02871.79 1/14/09854.05867.28836.93842.62 1/15/09840.45851.59817.04843.74 1/16/09858.13858.13830.66850.12 1/20/09841.91849.64804.47805.22 1/21/09818.63841.72804.30840.24 1/22/09820.40839.74811.29827.50 1/23/09808.80838.61806.07831.95 1/26/09834.57852.53827.69836.57 1/27/09841.64850.45835.40845.71 1/28/09863.81877.86845.73874.09 1/29/09859.30868.89844.15845.14 1/30/09849.08851.66821.67825.88 2/2/09815.11830.78812.87825.44 2/3/09830.42842.60821.98838.51 2/4/09841.58851.85829.18832.23 2/5/09826.10850.55819.91845.85 2/6/09847.37870.75845.42868.60 2/9/09868.17875.01861.65869.89 2/10/09861.98868.05822.99827.16 2/11/09833.36838.22822.30833.74 2/12/09818.72835.48808.06835.19 2/13/09832.90839.43825.21826.84 2/17/09803.11818.61789.17789.17 2/18/09793.83796.17780.43788.42 2/19/09795.19797.58777.03778.94 2/20/09768.20778.69754.25770.05 2/23/09777.52777.85742.37743.33 2/24/09746.51775.49744.69773.14 2/25/09767.63780.12752.89764.90 2/26/09775.23779.42751.75752.83 2/27/09736.03751.27734.52735.09 3/2/09719.75729.57699.70700.82 3/3/09710.16711.67692.30696.33 3/4/09708.76724.12698.60712.87 3/5/09697.42708.27677.93682.55 3/6/09688.18699.09666.79683.38 3/9/09675.13695.27672.88676.53 3/10/09691.44719.60679.28719.60 3/11/09724.34731.92713.85721.36 3/12/09720.62752.63714.76750.74 3/13/09755.39758.29742.46756.55 3/16/09764.50774.53753.37753.89 3/17/09754.84778.12749.93778.12 3/18/09772.08803.04765.64794.35 3/19/09804.87803.24781.82784.04 3/20/09789.40788.91766.20768.54 3/23/09789.14823.37772.31822.92 3/24/09811.32823.65805.48806.12 3/25/09811.83826.78791.37813.88 3/26/09822.53832.98814.06832.86 3/27/09819.52828.68813.43815.94 3/30/09797.29809.07779.81787.53 3/31/09795.83810.48790.88797.87 4/1/09785.01813.62783.32811.08 4/2/09830.66845.61814.53834.38 4/3/09835.67842.50826.70842.50 4/6/09832.49839.75822.79835.48 4/7/09888.53834.12814.53815.55 4/8/09819.48828.42814.84825.16 4/9/09845.37856.91829.29856.56 4/13/09847.32864.31845.35858.73 4/14/09849.79856.88840.25841.50 4/15/09837.66852.93835.58852.06 4/16/09858.72870.35847.04865.30 4/17/09870.59875.63860.87869.60 4/20/09854.15868.27832.39832.39 4/21/09827.46850.09826.83850.08 4/22/09841.58861.78840.57843.55 4/23/09847.15852.87835.45851.92 4/24/09859.45871.80853.91866.23 4/27/09854.65868.83854.65857.51 4/28/09847.89864.48847.12855.16 4/29/09862.17882.06856.85873.64 4/30/09882.91888.70868.51872.81 5/1/09873.00880.48866.10877.52 5/4/09885.58907.85879.21907