How to turn off weekends on date axis?

[sovietchild]

Hello I have a chart of 20 days and when I do the graph everything okay but the weekend. How to turn off weekends on date axis? Because it's empty.

[JieJenn]

Change your Axis type to Text Axis.

https://www.extendoffice.com/documen...-weekends.html

[sovietchild]

Change your Axis type to Text Axis.

https://www.extendoffice.com/documen...-weekends.html

I already did that but it's not in date order.

I like how it automatically makes the date in order but it also gives you weekends which I don't want.

[sovietchild]

I think I figured out. You have to change chart type to "Area"

[JieJenn]

Well, Excel is not perfect. If you sort your table from earliest date to the latest it will solve the sorting issue.

[sovietchild]

Well, Excel is not perfect. If you sort your table from earliest date to the latest it will solve the sorting issue.

Oh...I think you gave me an idea. Make it a table! Thanks

[sovietchild]

It works. Thanks.