Weekend dates show on chart, not on spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks,
 
Carole -

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/
_______
 
Back
Top