I am trying to create a that shows the dates 1996-2006 on the x axis. Everytime I try to change the the time scale showing these years the line graph information disappears. Can someone pls help. thanks
1996-2006 are not dates, they are years. If you tell a chart to use the date 1996, it thinks you mean the 1996th day in Excel's calendar system, which was 18 June 1905. You have at least three choices: 1. Use a category scale with years as X labels. 2. Use dates, like 1/1/1996, 1/1/1997, etc. 3. Use an XY chart with years as X values. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tomeka" wrote in message news:919050A2-C036-4E77-AC71-5188E17D4F39@microsoft.com... >I am trying to create a that shows the dates 1996-2006 on the x axis. > Everytime I try to change the the time scale showing these years the line > graph information disappears. Can someone pls help. > > thanks
