How to put Weekdays and Weekends on the x-axis of a graph

i have hourly data of entire week in excel, , want plot it! when so, in x-axis appears hours of week (i.e, 1 168), expected. prefer appear days of week, i.e., instead of first 24h, appear 'monday'.

thank in advance!

you can create column calculates weekday datetime value. put calculated weekday in 1 column next hourly data, , select column x-axis.