How to create a good chart to show average movement

Hello. I have a list of 30 days in a month. Typically the most volume is Mondays and the least volume is Saturdays and Sundays. When I create a chart, it really just highlights the up and down weekday/weekend spike. I'd like to see how the average is moving throughout the month. Is there a way to do this with excel? Spreadsheet attached.