View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day Kelly O'Day is offline
external usenet poster
 
Posts: 103
Default Data Points regarding DATES

F Lawrence Kulchar

I use trend charts with Excel 2003 all the time and have not run into your
problem. Are you using Excel 2003 or 2007?

A question - How is your X axis formatted? Is it date or serial format?

Kelly O'Day

http://processtrends.com




"F. Lawrence Kulchar" wrote in
message ...
I have numerous graphs wherein the X Axis represents the DATE.

When I scroll my mouse along the graph line (searching for data points), I
often see the accompanying data as...

Series 1 Point "39409"
Value 209
instead of:

Series 1 Point "22-Nov"
Value 209

HOW CAN I AVOID THE REFERENCE ON THE DATA LINE FROM REFLECTING THE
SERIAL NUMBER INSTEAD OF THE DATE ITSELF??? (such as "22-Nov".)

Thanks,

FLKulchar