If you wish to sort by days on the 7 days, format the cells to show the working day on the week. If you would like sort via the working day of your week whatever the day, change them to text by utilizing the TEXT function. , Excel authorities Mr. https://www.customguide.com/excel/how-to-make-a-graph-in-excel