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?
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.
Best Office Productivity Tools
Easy to Uninstall Completely | Supports Office/Excel 2007-2021 and 365 | Full-Featured 30-Day Free Trial | Available in 44 Languages
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!