Hi Dan,
Yes, there is a way to set the graph to only show weekdays and skip weekends. Here are the steps:
- Select the chart and right-click on the x-axis.
- Click on "Format Axis" in the drop-down menu.
- In the "Format Axis" pane that appears on the right-hand side of the screen, under "Axis Options", look for the "Axis Type" section.
- Click on the drop-down menu under "Axis Type" and select "Text axis".
- Under "Text axis", look for the "Date axis" section.
- Click on the drop-down menu under "Date axis" and select "Weekday".
- Click "Close" to close the "Format Axis" pane.
Your chart should now only show weekdays and skip weekends on the x-axis.