You can change the horizontal axis to match the date as per your requirement by clicking it twice and then change the axis maximum and minimum options.You can use it in any recent version of excel. As we have tested it in 2007 and 2010. Click image to download spreadsheet