hep with chart and Pivot Table

[rv02]

Hi All
I have a spreadsheet, which I have attached. I am trying to produce a report that shows me which sales associate has scored less than 2. I want to draw a graph for each week number for Sales Associates who have scored 1 or less. I also want to produce a pivot chart for each week. I cannot get the week numbers appear in pivot chart as I am not sure I have designed this spreadsheet properly to give me the result which I need in my Pivot table. Also I need to know how do I plot a chart just for those who have scored 1 or zero for each week.

Any help is appreciate it.

[noboffinme]

Hi rv02,

Your data isn't setup for you to do what you want.

Have a look at the attached.

[rv02]

Thanks for this.

[noboffinme]

Once you have populated the table in the format I have posted, let me know as we can then create your Pivot Table.

[rv02]

I have now uploaded the populated sheet as per your request.

I appreciate your help

[noboffinme]

Thanks, have a look at the attached.

This would be one way of presenting the data.

[rv02]

Thank you so much for your help. This is exactly what I needed