Thread: How do I get the date correct in excel 2000 on a chart?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis
 
Posts: n/a
Default How do I get the date correct in excel 2000 on a chart?
You probably need to switch to an "XY (Scatter)" chart. A "Line" chart
treats the x-axis values as 1,2,3,... which as dates would be 1Jan1900,
2Jan1900, ...

Jerry

Racheb wrote:

When I create a line graph, the date comes up as 00 instead of 05. I have the
correct cell formating (it's set to date format) and I've tried different
date formats.

Reply With QuoteReply With Quote