Richard Goh

Posts: n/a

graph dates revert to 1900

I am attempting to plot my investments value against dates with Excel 2000
in a Windows XP SP2 system
I have over 750 date rows, with gaps starting in 2003
When I choose a scatter chart, the dates on the chart revert to Jan 1, 1900
It was working up until the number of rows exceeded 699.

Is this a problem with Excel? Is there a limit to the number of rows that
can be used?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
how to create dates before 1900	Pieter	Excel Worksheet Functions	2	February 3rd 05 09:06 PM
how do I get excel to format dates before 1 jan 1900	keithcarteruk	Excel Discussion (Misc queries)	1	February 3rd 05 05:23 PM
Dates before 1900	David Cleave	Excel Worksheet Functions	1	January 18th 05 12:37 PM
Need to sort dates before 1900 in proper order	sandage_2000	Excel Discussion (Misc queries)	3	January 8th 05 03:31 AM
Dates prior to 1900	Kenn Tews	Excel Worksheet Functions	0	November 22nd 04 02:49 AM

All times are GMT +1. The time now is 06:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us