View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Custom x axis labels

Not sure if I really understand your question. Do you mean that the chart is
inserting extra intermediate dates. If so, this is a problem with charts and
the work around is to make the dates text at the source. (place a single
leading quote before the date.)

If this is not the problem, then post a sample of your data containing the
dates and mark which ones you want on the chart.

--
Regards,

OssieMac


"morlo" wrote:

I am plotting a chart showing monthly index yields.

My first date is 29th May 1981 and the last 30th June 2009. My x-axis
currently has two yearly spaced dates showing (ie 29th May 1981, 83, 85
etc...) but I really want it to be labelled 29th May 1981 then 31st December
1982, 31st December 1984 and so on...to 31st December 2008.

How can I achieve this? Am happy to add the first one manually but I really
want all of the December ones to be the general default.

Thanks

Rachel