Data Points regarding DATES

[F. Lawrence Kulchar]

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

 

[Kelly O'Day]

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

 

[FLKulchar]

I am using EXCEL 2002

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

 

[Andy Pope]

Hi,

I can only replicate what you are seeing if the cells are formatted as
numbers and the chart axis is formatted as Date.
Is the formatting of the axis linked to the cells? Double click the Axis and
on the Number tab check the Linked to source checkbox.

Cheers
Andy