This is my first post so apologies if I have posted in the wrong area or made mistakes regarding best practice when posting questions. I have data which looks something like this:
And I am hoping to get a chart or matrix table which has the specific number of coloured icons in place of the number. Preferably something like the picture below, which gives a great "big picture" view of the projects being completed across three different dimensions without looking unneccesarily messy. I have found timeline visuals which look good but can't seem to replace the time axis with a stage axis.
Any help in getting the above visual or even potential workarounds is appreciated.
Solved! Go to Solution.
Thanks for the response @lbendlin.
Here is a table of what the data might look like:
|Project 1||Team 1||Type 1||Stage 1|
|Project 2||Team 1||Type 2||Stage 2|
|Project 3||Team 1||Type 3||Stage 3|
|Project 4||Team 2||Type 1||Stage 4|
|Project 5||Team 2||Type 2||Stage 1|
|Project 6||Team 2||Type 3||Stage 2|
|Project 7||Team 3||Type 1||Stage 3|
|Project 8||Team 3||Type 2||Stage 4|
|Project 9||Team 3||Type 3||Stage 1|
|Project 10||Team 4||Type 1||Stage 2|
|Project 11||Team 4||Type 2||Stage 3|
|Project 12||Team 4||Type 3||Stage 4|
|Project 13||Team 1||Type 3||Stage 2|
|Project 14||Team 2||Type 2||Stage 1|
|Project 15||Team 2||Type 2||Stage 1|
|Project 16||Team 3||Type 2||Stage 1|
|Project 17||Team 4||Type 2||Stage 1|
And here is an updated picture of what the desired outcome would look like based on this sample data above:
A table with coloured icons in place of numbers, where each icon represents a project, and colour to represent the type. I'm also open to any alternative suggestions for conveying this executive summary of the projects in such a simple concise way.
Hope this is more helpful.
Welcome to the forums. Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.