Creat Graph in Excel

1. California 2011 Energy Sources. Content: A graph fashioned to show the percentage of the whole that each type represents from "2001 to 2011 generation.csv". Note that the graph should show only the 2011 data. 2. California 2011 Energy Consumption. Content: A graph fashioned to show the percentage of the whole that each consumption type represents from "consumption by sector.csv". Note that the graph should show only the 2011 data. [login to view URL] 2002 to 2011 Energy Sources. Content: A graph fashioned to show what each energy source contributed each year from “2001 to 2011 generation.csv”. Note that the graph should show only the ten years 2002 through 2011.