View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JeanEM JeanEM is offline
external usenet poster
 
Posts: 2
Default How do I show yyyy only on x axis of a chart?

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".