This is my first time in Chandoo!! We post our daily production Monday through Friday. I would like to build a chart that captures all of the Mondays, Tuesdays, etc.
what version of excel do you have? how would you rate your experience/knowledge in Excel?
do you already have the data in an Excel Spreadsheet?
My first suggestion, without seeing how you have the data if it is already entered into a spreadsheet or knowing what youre trying to achieve with your chart, would be to look into a pivot table as it allows good, flexible options with filtering data, reorganizing how the data is displayed, etc.
can you explain (or even upload a sample) how your data is getting entered into the spreadsheet and explain what the layout is like?