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.
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.
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.
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" <post_a_reply@no_e-mail.com> wrote in message
news:43A0ADF3.7040503@no_e-mail.com...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks