Concatenated Legend Series with grouped Colours

[jomaor1]

Hello!

So I'm trying to group Names by only 3 colors in my chart, Backlog/Won Not Booked/Forecast.
Just like the image below, and the attachment.
But the chart insists on coloring the columns by each Name instead of my 3 previous statements.

Is there a way of doing this automatically, or I will have to create other tables to help me?
If yes, how ?

Thank you!

Capture.PNG