1. Na listu PAHy najdete měsíční koncentrace polyaromatických uhlovodíků v letech 2003-2012. "2. Aktivujte buňku B3 na listu PAHy a zahajte záznam makra, které pojmenujete Graf." 3. V režimu záznamu makra vytvořte sloupcový graf o čtyřech sloupcích udávajících koncentrace PAHů dne 15.10.2003 s legendou převzatou z řádku 2 a názvem grafu odpovídajícím kalendářnímu datu. 4. Přiřaďte makru klávesoou zkratku Ctrl+Shift+Q. 5. Přemístěte kurzor do buňky B4 a pomocí klávesové zkratky spusťte makro Graf za účelem vytvoření grafu obsahujícího údaje z řádku 4. ##### Sheet/List 2 ##### middle date fluorene phenantrene fluoranthene pyrene 10/15/2003 434.4 1091.8 297.4 156.2 11/12/2003 479.0 1425.8 327.2 158.2 12/10/2003 705.8 2222.2 635.6 335.4 1/7/2004 1069.4 3792.4 1030.4 483.6 2/4/2004 630.8 2142.0 674.2 266.0 3/3/2004 745.0 2181.8 639.2 243.2 3/31/2004 246.8 786.0 266.0 126.4 4/28/2004 126.8 464.4 142.4 72.0 5/26/2004 89.6 269.4 68.0 36.0 6/26/2004 55.9 163.2 44.9 21.9 7/27/2004 5.6 55.8 27.2 13.0 8/24/2004 37.4 108.8 32.6 15.8 9/21/2004 143.4 408.6 130.5 73.4 10/20/2004 442.8 1328.6 405.5 205.9 12/1/2004 1853.5 5524.4 1273.6 691.4 1/12/2005 898.2 2967.0 823.2 501.8 2/9/2005 688.0 1893.1 460.8 241.2 3/9/2005 569.8 1817.6 494.6 204.4 4/6/2005 216.6 700.4 306.6 348.6 5/4/2005 64.7 193.8 84.8 106.4 6/1/2005 140.0 363.6 103.4 42.6 6/29/2005 138.2 296.0 60.0 23.2 7/27/2005 94.4 293.2 82.4 52.6 8/24/2005 97.4 272.6 111.6 193.2 9/21/2005 58.0 137.8 61.0 38.0 10/19/2005 417.6 1066.8 414.7 275.8 11/16/2005 1354.4 3156.5 741.5 507.0 12/14/2005 1261.4 3246.1 1107.7 541.3 1/11/2006 1003.5 2294.0 418.4 181.9 2/8/2006 1392.1 3389.9 614.4 241.5 3/8/2006 612.8 2507.7 499.4 148.0 4/5/2006 387.7 1367.1 296.6 125.5 5/3/2006 125.8 445.3 113.7 50.6 5/31/2006 99.0 299.2 77.9 33.0 6/28/2006 82.2 221.3 58.5 24.8 7/26/2006 84.3 214.3 86.8 138.4 8/23/2006 53.8 148.1 43.2 23.2 9/20/2006 75.0 171.5 56.1 29.9 10/18/2006 210.0 571.1 164.9 93.1 11/15/2006 390.5 1202.4 335.4 179.3 12/13/2006 663.3 1860.9 471.9 258.4 1/10/2007 218.5 880.9 342.0 169.5 2/7/2007 390.6 1066.5 372.4 204.4 3/7/2007 256.7 843.6 272.1 30.8 4/4/2007 176.7 501.2 171.9 76.4 5/2/2007 102.7 317.4 109.4 51.3 5/30/2007 51.4 146.4 38.1 18.6 6/27/2007 33.7 80.1 1.7 3.7 7/26/2007 37.4 90.4 29.3 12.5 8/23/2007 62.5 157.8 44.2 23.5 9/19/2007 122.8 316.8 121.7 51.6 10/17/2007 342.7 842.7 262.2 150.2 11/14/2007 441.0 1279.5 365.5 195.9 12/12/2007 849.8 2461.2 671.9 322.1 1/24/2008 1239.2 4255.5 1081.5 494.5 2/21/2008 826.2 2899.6 784.0 370.9 3/19/2008 355.3 1239.3 352.1 161.9 4/16/2008 216.2 675.0 201.3 97.7 5/14/2008 95.5 317.9 101.8 53.8 6/11/2008 42.4 119.8 42.7 28.3 7/9/2008 72.8 222.6 56.1 23.6 8/6/2008 48.7 139.0 46.1 20.6 9/3/2008 87.6 183.1 52.6 28.6 10/1/2008 214.0 632.8 185.6 98.6 10/29/2008 264.9 841.8 224.7 108.9 11/26/2008 445.9 1351.6 377.1 179.6 12/24/2008 1119.3 2743.3 674.6 307.3 1/21/2009 1295.3 3065.8 707.5 283.0 2/18/2009 534.7 1619.7 442.8 174.3 3/18/2009 209.2 672.9 202.8 86.8 4/15/2009 55.1 174.2 59.6 26.4 5/13/2009 33.9 113.6 38.7 18.1 6/10/2009 22.0 67.3 17.5 9.0 7/8/2009 18.1 61.2 18.3 9.1 8/5/2009 14.5 38.6 12.4 6.0 9/2/2009 32.8 73.9 22.9 12.2 9/30/2009 892.4 2980.5 941.7 571.8 10/28/2009 460.6 1177.1 322.8 166.6 11/25/2009 233.6 813.2 251.4 137.9 12/23/2009 701.8 1846.8 446.5 188.6 1/20/2010 723.1 1738.9 412.1 147.2 2/17/2010 680.8 1673.4 407.9 136.6 3/17/2010 263.6 935.4 308.3 113.9 4/14/2010 114.5 351.1 145.8 68.9 5/12/2010 106.8 366.7 131.5 60.7 6/9/2010 130.7 390.4 149.7 74.8 7/7/2010 73.0 186.0 76.7 31.6 8/4/2010 49.8 143.8 41.1 20.7 9/1/2010 82.8 271.7 93.8 54.9 9/29/2010 298.5 737.9 242.4 128.5 10/27/2010 155.0 439.3 139.6 71.0 11/24/2010 655.9 1517.6 358.4 186.5 12/22/2010 664.9 1762.7 444.6 193.7 1/19/2011 729.6 1852.7 469.7 198.7 2/16/2011 759.4 1624.3 392.5 155.9 3/16/2011 332.7 966.6 291.5 124.0 4/13/2011 174.7 561.2 152.6 65.9 5/11/2011 90.4 276.0 98.7 48.3 6/8/2011 153.4 474.5 180.4 84.4 7/6/2011 166.5 487.9 208.2 88.2 8/3/2011 24.3 69.5 22.1 11.1 8/31/2011 43.9 108.1 45.5 24.0 9/28/2011 147.1 404.8 130.4 76.0 10/26/2011 619.3 1704.6 683.8 343.4 11/23/2011 827.8 2544.9 803.3 435.3 12/21/2011 412.1 1650.8 601.7 318.4 1/18/2012 941.7 2271.6 749.7 363.7 2/15/2012 1006.7 3190.8 968.4 416.7 3/14/2012 272.6 957.3 368.3 184.1 4/11/2012 155.5 540.6 226.6 109.5 5/9/2012 49.9 173.6 94.7 39.9 6/6/2012 34.2 92.1 35.3 12.7 7/4/2012 38.1 103.9 38.2 19.2 8/1/2012 32.4 78.3 28.9 13.2 8/29/2012 53.8 132.0 43.5 25.8 9/26/2012 64.9 205.5 73.5 45.1 10/24/2012 272.0 857.4 292.3 146.5 11/21/2012 453.8 1301.6 445.2 220.6