Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get the date correct in excel 2000 on a chart?
When I create a line graph, the date comes up as 00 instead of 05. I have the
correct cell formating (it's set to date format) and I've tried different date formats. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get the date correct in excel 2000 on a chart?
You probably need to switch to an "XY (Scatter)" chart. A "Line" chart
treats the x-axis values as 1,2,3,... which as dates would be 1Jan1900, 2Jan1900, ... Jerry Racheb wrote: When I create a line graph, the date comes up as 00 instead of 05. I have the correct cell formating (it's set to date format) and I've tried different date formats. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get the date correct in excel 2000 on a chart?
If the dates were actually used as the X values, this wouldn't be an issue
for either the XY or Line chart types. Choose Source Data from the Chart menu, click on the Series tab, and select the series. Make sure the range of dates is entered in the Category Labels (or X Values) input box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jerry W. Lewis" wrote in message ... You probably need to switch to an "XY (Scatter)" chart. A "Line" chart treats the x-axis values as 1,2,3,... which as dates would be 1Jan1900, 2Jan1900, ... Jerry Racheb wrote: When I create a line graph, the date comes up as 00 instead of 05. I have the correct cell formating (it's set to date format) and I've tried different date formats. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date analysis key in Excel 2000 | New Users to Excel | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |