Thread: Leap Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ralph Page Ralph Page is offline
external usenet poster
 
Posts: 2
Default Leap Year

I often chart data that spans several years and I haven't found a
method to have the x axis (date) accommodate leap years so the grid
will correspond to Jan 1 in each year. These charts are always XY
charts.

So far I have just selected 365 as the major unit and lived with it.

It would seem a logical chart option for XY charts would include
months or years rather than a specific number of days. Is that
feature available in a spot I haven't found yet?

I'm using Excel 2002.

Thanks

--
-Ralph Page
remove pants to reply by email