How to organise data for my graph

You need to create a summary table in order to chart it. See Example 1 sheet.

You may find it easier to separate the data from the report layout. See Sheet1
Then you can use pivot table / chart to report.

Sheet2 replicates report layout, including ranking of reasons within person.
Sheet3 contains chart summary of person by period