| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting data series - line between certain data points only | Charts and Charting in Excel | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| Data is added together instead of separate data points | Charts and Charting in Excel | |||
| Add data labels without displaying data points? | Charts and Charting in Excel | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Linear Mode
