Weekend dates show on chart, not on spreadsheet

C

CaroleO

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,
 
J

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
How to automate update on weekly reports spreadsheet 0
Creating a Chart on form from selected data in query. 0
Show only workdays in chart axis? 4
2016 Project, adding a workday to custom field 0
XY Charts Excluding Weekends 1
How to remove weekends from the chart 2
Project Pro - Reports (Resource work) 0

Top