How to Make a Year Graph in Excel. Microsoft Excel 2010 gives you a number of graphing options so you can display the information in your spreadsheet in many different ways.