Edit/Create a Multi Wheeled Diagram

[stroffso]

I was given this multi wheeled diagram that has 6 equal header sections with 3 subsections each split into 5 rankings 1-5 where the chart colours blue for each rating one to five. Eg with the below test 5 has a rating of 3/5, Test 9 is 4/5

I would like to change it so there are only 5 main header sections, 4 of which are split into 3 sections and 1 split into 2 sections still with the 1-5 rating. Does anyone know if this is achievable in Excel? Currently the file runs some VBA which populates the colours but I am not sure how to edit so it can change the chart layout. Code also below, all help greatly welcome

Sub Wheel()


For i = 1 To 90
Range("actReg").Value = Range("Macro!A" & i).Value
ActiveSheet.Shapes(Range("actReg").Value).Select
Selection.ShapeRange.Fill.ForeColor.RGB = Range(Range("actRegCode").Value).Interior.Color

Next i

Range("A5").Select



End Sub