Chart Type,Example,Chart,Data,Month,Year Vertical Bar,"=BARCHART(D2:D13)",,4,Jan,2001 Horizontal Bar,"=HBARCHART(D2:D13)",,6,Feb,2002 Line,"=LINECHART(D2:D8, F2:F6)",,7.2,Mar,2003 Pie,"=PIECHART(D2:D8, E2:E8)",,7.5,Apr,2004 ,,,8.2,May,2005 ,,,9.1,Jun,2006 ,,,14.1,Jul,2007 ,,,16,Aug,2008 ,,,17.9,Sep,2009 ,,,22,Oct,2010 ,,,30,Nov,2011 ,,,32,Dec,2012 ,,,,, ,,,,,