Status Report / Table

Hello, I am stuck with piecing together what I thought would be a simple visualisation.

I'm trying to build a report to go into a dashboard that shows the status of various projects in a table like this:

I need the columns across the top to run left to right in a specific order and beneath that I want my Project Names to line up in their 'buckets' by status underneath.

How best to achieve this with a chart or report that I can fold into a dashboard for easy sharing across the project?

As you might imagine my data is held in a typical grid with the Project Name in the Primary column and in another column I have Project Status as a field limited dropdown.

Hope you can help.

Many thanks,


Best Answer