Chart formatting with dates

  • Thread starter Thread starter paulabrozek
  • Start date Start date
P

paulabrozek

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:

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

(e-mail address removed)






"paulabrozek" <[email protected]>
wrote in message
news:p[email protected]...
 
Back
Top