How to correctly scale X-Axis in Charts?
 

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

How to correctly scale X-Axis in Charts?
 

you 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.

"Peter Bernadyne" wrote:


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

How to correctly scale X-Axis in Charts?
 

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

"Marvin P. Winterbottom" wrote:

you 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.

"Peter Bernadyne" wrote:


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

How to correctly scale X-Axis in Charts?
 

Thanks very much!!! I really appreciate this.


--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017
View this thread: http://www.excelforum.com/showthread...hreadid=494999