I am collecting data for workdays, so the weekend dates do not show on the spreadsheet. When I create the chart, the weekend dates show. How do I eliminate them from the chart
Right click on the chart, choose Chart Type from the pop up menu, and
make sure it's a Line chart not a Scatter chart. Then right click again,
this time choose Chart Options, and on the Axes tab, change Automatic to
Category.
Now you'll only have an axis tick where you have a date in your data table.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______