I'm using dates in the horizontal legend of a column chart. On the data
source, there are only columns for the days we actually worked, i.e. there
are no columns for the dates for Sat, Sun, Holidays, etc. There are no
hidden columns in the sheet.

When I select that area for the horizontal legend and view the chart, all
dates are displayed in the legend, leaving gaps in the chart. I remember a
similar problem in Excel 2003.

What am I missing?

Thanks.
--
Hal the CFO