Date Formats in Excel Chart

[zth0031]

Does anyone know how to format the dates on an Excel chart so they reflect the actual date and not the 1st of each month? My source data has dates that are 4 weeks apart (i.e. 8/14/05, 9/11/05, 10/9/05) and when they show up in the graph they read as 8/1/05, 9/1/05, 10/1/05. I have tried formatting every way I can think of and cant get it to change. Any help would be greatly appreciated.

T

 

[Damon Ostrander]

Hi T,

I suggest you change the chart type from Scatter to Line. The Line-type chart will read the abscissa values as text strings and will therefore use exactly those values to label the axes.

Damon