Hi,
I have this problem as well.
I've tried doing this, but it doesn't seem to work. For example, I
have the following data to plot:
01/31/95 0.29623
12/29/95 0.19822
12/31/96 0.13931
12/31/97 0.33036
12/31/98 0.082194
12/31/99 0.23669
12/29/00 -0.25575
12/31/01 0.023404
12/31/02 -0.11949
12/31/03 -0.018228
12/31/04 0.12326
with the dates being the actual dates I wish to plot on my x-axis. As
you can see, they are irregular dates. Regardless of how I try (with
ensuring the Minor Unit is on Days and the Major on months), I can't
seem to get the right combination to have Excel plot the actual dates
above. Instead, it seems to keep defaulting to the last day in
January, probably due to the first data point in the date series.
Does anyone have any ideas how I would fix this to get the actual dates
to plot on the x-axis?
Thanks,
-Pete
--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile:
http://www.excelforum.com/member.php...fo&userid=7017
View this thread:
http://www.excelforum.com/showthread...hreadid=486649