| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Point on Graph "39409 versus 11/23/07"
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 Point on Graph "39409 versus 11/23/07"
What version of Excel are you using. In Excel 2003 I see 22-Nov in the
yellow screen-tip box with Column, Line or XY chart. Tell us more about the chart. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "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 Point on Graph "39409 versus 11/23/07"
The chart is a Combination Chart that does NOT match any of the available
chart types . I am using Excel 2002 SP3 The range for the "Category (x) axis lables " is: Sheet1!$B$18:$B$550 and the range for Series 1 is: Sheet1!$W$18:$W$550 And, as stated, when I click my mouse along the Series 1 line, I sometimes get for its value..."39409" instead of 11/23/2007...((Sometimes...but NOT always). Please explain, and, Thank you!! FLKulchar "Bernard Liengme" wrote in message ... What version of Excel are you using. In Excel 2003 I see 22-Nov in the yellow screen-tip box with Column, Line or XY chart. Tell us more about the chart. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "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 | |||
| How do I make a "fuel gauge" type graph (from 1-5) to show data | Charts and Charting in Excel | |||
| Series 1 Point "0" Data Label | Charts and Charting in Excel | |||
| How do I keep graph "data table" formats in separate excel workboo | Charts and Charting in Excel | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Data "Point" in graph not matching table | Charts and Charting in Excel | |||
Linear Mode
