Hello,
I am looking to build a simple Impact-Effort Matrix graph. After extracting some survey data, I run a macro to populate a table as such:
This is based on a sample size of 8 voters who rate each project on whether a project is high/low in terms of effort and impact.
A project is rated High Impact (or whichever) as long as >50% votes are received. Hence, Project 1 is rated as High Impact and High Effort.
I want to be able to represent this data into a quadrant that just simply shows the project name in the quadrant it is supposed to be in. Something like this (the axes would be effort and impact:
Is there some way to do it? Apologies for the longish query and thanks in advance for any advise.
I am looking to build a simple Impact-Effort Matrix graph. After extracting some survey data, I run a macro to populate a table as such:
High Impact | Low Impact | High Effort | Low Effort | |
Project 1 | 5 | 3 | 8 | 0 |
Project 2 | 5 | 3 | 6 | 2 |
Project 3 | 4 | 4 | 0 | 8 |
Project 4 | 2 | 6 | 3 | 5 |
Project 5 | 3 | 5 | 8 | 0 |
Project 6 | 3 | 5 | 4 | 4 |
Project 7 | 4 | 4 | 3 | 5 |
Project 8 | 4 | 4 | 4 | 4 |
Project 9 | 5 | 3 | 5 | 3 |
Project 10 | 4 | 4 | 4 | 4 |
This is based on a sample size of 8 voters who rate each project on whether a project is high/low in terms of effort and impact.
A project is rated High Impact (or whichever) as long as >50% votes are received. Hence, Project 1 is rated as High Impact and High Effort.
I want to be able to represent this data into a quadrant that just simply shows the project name in the quadrant it is supposed to be in. Something like this (the axes would be effort and impact:
Project 1 Project 2 Project 9 | |
Project 4 | Project 5 |
Is there some way to do it? Apologies for the longish query and thanks in advance for any advise.