I have a daily sales spreadsheet for the entire year - Weekday, Date, Orders, Guest, Sales in Columns (365 rows - one for each day). (There is more data to this table, and it is formatted and imported into Excel in rows for each day.)
I want to make 7 graphs, one for each day of the week (Mondays for example) to see how Total Sales for each day trends over time. How do I provide that logic in the graph parameter other than manually selecting each date, one by one?
Any help would be appreciated.