If you are making a line chart with data such as this
Year Sales
2004 1234
2005 2456
....
Excel will treat both columns as data series and the x-axis will be 1,2,3,
If you delete the text "Year" than make the chart, Excel will see the first
column as you category values. You can add the text back in after making the
chart
Alternatively, make an XY chart
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"JeanEM" wrote in message
...
I did not use a formula for the date (4-digit year only) in column A, I
manually entered the years.
When I attempt to create a chart, the years either show up as 1, 2, 3, etc
or as m/d/yyyy with the year showing in all instances as 1900.
Can you help me enter the yyyy only on the x axis of the chart?
Unfortunately there is no option for yyyy in "format cellsdate".