Data Points regarding DATES
 

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

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

Data Points regarding DATES
 

I am using EXCEL 2002
"Kelly O'Day" wrote in message
...
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

Data Points regarding DATES
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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