If you'd like to sort by days from the 7 days, format the cells to show the working day of the week. In order to sort from the working day from the 7 days whatever the date, change them to text by utilizing the TEXT function. Notes: Prospective Challenges Check https://www.customguide.com/excel/how-to-make-a-graph-in-excel