Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
dboudry
 
Posts: n/a
Default date in scatter chart excel 2003


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: http://www.excelforum.com/member.php...o&userid=32526
View this thread: http://www.excelforum.com/showthread...hreadid=523104

  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default date in scatter chart excel 2003

Dave
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



"dboudry" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=32526
View this thread: http://www.excelforum.com/showthread...hreadid=523104



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text, Number and Date formats excel 2003 driving experienced user E F Bat Excel Discussion (Misc queries) 1 January 6th 06 08:10 PM
Excel 2003 xy chart - problem plotting more than 330 points ehmcneill Charts and Charting in Excel 1 December 17th 05 01:18 AM
How to prevent Excel 2003 from automatically change chart type Oscar II Charts and Charting in Excel 2 October 1st 05 02:57 PM
Excel 2003 Inserting current date mark Excel Discussion (Misc queries) 3 February 9th 05 06:51 PM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 01:19 AM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"