How do you not include weekends from the X-axis?
I've already modified the date field so it never has a saturday or sunday for the field I'm using on the x-axis yet the dates still show up leaving 2 day gaps of no data.
So since you already have the values removed for Saturday and Sunday the last step would be to go to the X-axis under chart properties and set 'Never Use Time Scale' to True. You may need to play around with the Date Output Format after that, but hopefully that helps.
Let me know if you have any questions,
**Please mark "Accept as Solution" if this post solves your problem**Say "Thanks" by clicking the "heart" in the post that helped you.