close

Hey all,

I'm having problems with dates in scatter charts in excel 2003. All
dates appear in the year 1900. When I choose any other chart type,
this works fine, but I definitly need to use scatter chart. When I
select line chart and change the X Aces value in the chart options to
Time-scale, I get the same result as in a scatter chart (year 1900).
In excel XP(2002), this works fine. Does anyone have a solution to
this issue?

regards,
Dave.--
dboudry
------------------------------------------------------------------------
dboudry's Profile: www.excelforum.com/member.php...oamp;userid=32526
View this thread: www.excelforum.com/showthread...hreadid=523104Dave
It sounds like you have a format issue so that Excel is not recognizing your
dates properly.

As you know, Excel treats dates as days from jan 1, 1900. the fact that you
are getting 1900 in both XY and Line (time-scale) charts says points to the
date format.

I have run into this when I import date data from Access. it looks just like
a date, however, Excel doesn't recognize it as date.

Does Excel let you reformat your dates? If no, then dates may be in text
format. You can use DateValue function to convert text in form of dates to
date serial number.

....Kelly
quot;dboudryquot; gt; wrote in
message ...
gt;
gt; Hey all,
gt;
gt; I'm having problems with dates in scatter charts in excel 2003. All
gt; dates appear in the year 1900. When I choose any other chart type,
gt; this works fine, but I definitly need to use scatter chart. When I
gt; select line chart and change the X Aces value in the chart options to
gt; Time-scale, I get the same result as in a scatter chart (year 1900).
gt; In excel XP(2002), this works fine. Does anyone have a solution to
gt; this issue?
gt;
gt; regards,
gt; Dave.
gt;
gt;
gt; --
gt; dboudry
gt; ------------------------------------------------------------------------
gt; dboudry's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32526
gt; View this thread: www.excelforum.com/showthread...hreadid=523104
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()