My guess is that the data on the worksheet is formatted "ddd" or "dddd" to
show days-of-the-week but the underlying data are actual dates. So try
formatting the axis labels (they are not legends but labels - legends are
the boxes that show how each data series is plotted when you have more that
one data series on a chart)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Hal" wrote in message
...
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