Excel 2007 : Excel 2007 chart horizontal axis dates

**xanthippie** · 11-07-2009, 07:15 PM

Does anyone know why when I try to use a scatter graph the horizontal axis when I try and add dates to it ends up not corresponding with the data points. I have posted the file. It is sheet 1.

**deadlyduck** · 11-07-2009, 08:07 PM

It might be the alignment of the X-axis.

To change, right click the dates, choose 'Format axis...' from the context menu and then 'Alignment' from the left panel of the dialog box. Set vertical alignment to 'Middle'

**shg** · 11-07-2009, 08:24 PM

I think this would be better represented as a line graph. You can set the min and max values as 1/1 as 12/1, and set the major units as months.

As an xy graph, the (linear) x axis will have a constant number of days between major units, and you want months, which are not constant in days.

You can still do your trendline; the slope will be in dollars per month.