Your table has weekday data and not weekend data, right? Make the chart.
Excel recognizes the dates and creates a time scale axis, which includes all
seven days per week. Go to Chart menu Chart Options Axes tab, and change
the Category (X) Axis option to Category. This now gives you categories only
where you have actual data, without gaps on weekends and holidays.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"par3" wrote in message
...
I have an excel spreadsheet that contains 52 weeks of data. I want to just
chart the weekdays not the weekends. How do I get the source data to be
just
that?