software

I posted this in Excel Charting, too, but I reckon it gets far fewer
readers...

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 in a
regular Excel line chart. 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 or it just gives me a regular monthly date by year (always
January 1, XXXX for instance).

Does anyone have any ideas how I would fix this to get the actual dates
above to plot on the x-axis?

Thanks,

-Pete--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile: www.excelforum.com/member.php...foamp;userid=7017
View this thread: www.excelforum.com/showthread...hreadid=494999you can't chang the values on the x-axis, that's just the scale it picks, you
can go into chart options/data labels/show labels, and it will put the actual
date by every data point.

quot;Peter Bernadynequot; wrote:

gt;
gt; I posted this in Excel Charting, too, but I reckon it gets far fewer
gt; readers...
gt;
gt; I have the following data to plot:
gt;
gt; 01/31/95 0.29623
gt; 12/29/95 0.19822
gt; 12/31/96 0.13931
gt; 12/31/97 0.33036
gt; 12/31/98 0.082194
gt; 12/31/99 0.23669
gt; 12/29/00 -0.25575
gt; 12/31/01 0.023404
gt; 12/31/02 -0.11949
gt; 12/31/03 -0.018228
gt; 12/31/04 0.12326
gt;
gt; with the dates being the actual dates I wish to plot on my x-axis in a
gt; regular Excel line chart. As you can see, they are irregular dates.
gt; Regardless of how I try (with ensuring the Minor Unit is on Days and
gt; the Major on months), I can't seem to get the right combination to have
gt; Excel plot the actual dates above. Instead, it seems to keep defaulting
gt; to the last day in January, probably due to the first data point in the
gt; date series or it just gives me a regular monthly date by year (always
gt; January 1, XXXX for instance).
gt;
gt; Does anyone have any ideas how I would fix this to get the actual dates
gt; above to plot on the x-axis?
gt;
gt; Thanks,
gt;
gt; -Pete
gt;
gt;
gt; --
gt; Peter Bernadyne
gt; ------------------------------------------------------------------------
gt; Peter Bernadyne's Profile: www.excelforum.com/member.php...foamp;userid=7017
gt; View this thread: www.excelforum.com/showthread...hreadid=494999
gt;
gt;

correction- you can change the scale, on chart optios/axis/ pick category,
then it puts the actual dates on the x-axis scale

quot;Marvin P. Winterbottomquot; wrote:

gt; you can't chang the values on the x-axis, that's just the scale it picks, you
gt; can go into chart options/data labels/show labels, and it will put the actual
gt; date by every data point.
gt;
gt; quot;Peter Bernadynequot; wrote:
gt;
gt; gt;
gt; gt; I posted this in Excel Charting, too, but I reckon it gets far fewer
gt; gt; readers...
gt; gt;
gt; gt; I have the following data to plot:
gt; gt;
gt; gt; 01/31/95 0.29623
gt; gt; 12/29/95 0.19822
gt; gt; 12/31/96 0.13931
gt; gt; 12/31/97 0.33036
gt; gt; 12/31/98 0.082194
gt; gt; 12/31/99 0.23669
gt; gt; 12/29/00 -0.25575
gt; gt; 12/31/01 0.023404
gt; gt; 12/31/02 -0.11949
gt; gt; 12/31/03 -0.018228
gt; gt; 12/31/04 0.12326
gt; gt;
gt; gt; with the dates being the actual dates I wish to plot on my x-axis in a
gt; gt; regular Excel line chart. As you can see, they are irregular dates.
gt; gt; Regardless of how I try (with ensuring the Minor Unit is on Days and
gt; gt; the Major on months), I can't seem to get the right combination to have
gt; gt; Excel plot the actual dates above. Instead, it seems to keep defaulting
gt; gt; to the last day in January, probably due to the first data point in the
gt; gt; date series or it just gives me a regular monthly date by year (always
gt; gt; January 1, XXXX for instance).
gt; gt;
gt; gt; Does anyone have any ideas how I would fix this to get the actual dates
gt; gt; above to plot on the x-axis?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; -Pete
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Peter Bernadyne
gt; gt; ------------------------------------------------------------------------
gt; gt; Peter Bernadyne's Profile: www.excelforum.com/member.php...foamp;userid=7017
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=494999
gt; gt;
gt; gt;


Thanks very much!!! I really appreciate this.--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile: www.excelforum.com/member.php...foamp;userid=7017
View this thread: www.excelforum.com/showthread...hreadid=494999