Chart formatting with dates
 

I made a chart that has dates on the x-axis. The dates are not in
consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis
format such that the dates fall in consecutive order and thus, makes my
plot uneven. How do I format so that the exact dates I've entered into
the cells show up on the x axis without adding any extra dates?

Thanks
Paula


--
paulabrozek
------------------------------------------------------------------------
paulabrozek's Profile: http://www.excelforum.com/member.php...o&userid=30377
View this thread: http://www.excelforum.com/showthread...hreadid=535107

Chart formatting with dates
 

Paulabrozek:

Excel is reading your ax values as dates and assumes that you want to make a
time series chart. for time series charts, Excel uses the day - month - year
conventions so that it plots your dates along a calendar based scale.

To get you dates to plot as you enter, not in colander order, you need to
make the text entries, not date entries. You can do this by placing an ' in
front of each date or you can enter a new column and formula:

B1 = Text(A1,"m/d/yyyy")

This formula will convert date in Cell A1 to text in B1. Then use you new
Column B values in stead of the original dates.

...Kelly








"paulabrozek"
wrote in message
...

I made a chart that has dates on the x-axis. The dates are not in
consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis
format such that the dates fall in consecutive order and thus, makes my
plot uneven. How do I format so that the exact dates I've entered into
the cells show up on the x axis without adding any extra dates?

Thanks
Paula


--
paulabrozek
------------------------------------------------------------------------
paulabrozek's Profile:
http://www.excelforum.com/member.php...o&userid=30377
View this thread: http://www.excelforum.com/showthread...hreadid=535107

Chart formatting with dates
 

Choose Chart Options from the Chart menu, click on the Axes tab, and choose
Categories instead of Automatic under Category (X) Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"paulabrozek"
wrote in message
...

I made a chart that has dates on the x-axis. The dates are not in
consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis
format such that the dates fall in consecutive order and thus, makes my
plot uneven. How do I format so that the exact dates I've entered into
the cells show up on the x axis without adding any extra dates?

Thanks
Paula