Excel 2003. On a chart with weekly data point values and a total range from
2000 through year to date 2006, the fact that 2004 had 53 weeks rather than
52 skews the yearly increments on the x-axis (bottom scale) on the chart. It
shows 2004 correctly, but shows 2004 again for the actual 2005 tick mark and
2005 for 2006. I've tried setting the number of catagories between the tick
marks at 53 (instead of 52), but it throws off the alignment of the year
label to the tick mark and it gets incrementally worse every year. Need a
way of making the scale on the x-axis ignore that 2004 had 53 weeks and show
accurate years at each tick mark.