How to exclude weekends in date axis in Excel?
In Excel, when you create a chart based on the data range including dates without weekends, it will automatically add the weekends into the chart axis as shown as below screenshot. How could you exclude the weekend dates in axis in Excel?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To exclude weekends in the date axis, you just need to format the axis as text axis.
1. Right click at the X axis and select Format Axis in the context menu. See screenshot:
2. In the popped out Format Axis dialog, check Text axis option in Axis Type section. See screenshot:
In Excel 2013, check Text axis option in the Axis Options section in the Format Axis pane.
3. Close the dialog. Then you can see the weekend dates are removed.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 7 months agoperfect this worked for me
To post as a guest, your comment is unpublished.· 8 months agoThank you worked perfect
To post as a guest, your comment is unpublished.· 2 years agoPerfectly worked. Thanks!!
To post as a guest, your comment is unpublished.· 2 years agoWorked perfect for me. Thanks!
To post as a guest, your comment is unpublished.· 3 years agoIt changes the way the text is then displayed. Poor work around.