The spreadsheet for daily into weekly sales doesn't chart well

Hi,

I was asked to create a chart to track daily sales and weekly sales of specific monthly products with individual item numbers. The idea is to see what the trends are, if more items are sold on specific days of the week and what type of items are more popular. I showed it to the person that asked me to create it and she requested I add in a column that lists the day of the week in addition to the column where I list the specific date. Other than that she said it looks fine but when I go to show it on a chart it looks like a big mess. How can I fix this?

Here is a sample of what im doing:

Maybe with a pivot table.

leeg = empty (cells)
eindtotaal = endtotal
rijlabel = rowlabel
kolomlabel = collumlable

Notice I put the weeknummers manualy in the sheet.

That can also be done by formula.

Do you have questions, just ask.