Chart Type,Example,Chart,Data,Month,Year Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001 Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002 Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003 Pie,"=PIECHART(D2:D8, E2:E8)",=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 ,,,,, ,,,,,