Impact Effort Matrix

[Brew]

Hello all

I need help with my Impact Effort Matrix. The records results in column C and D starting at row 5 is my Impact and Effort results. see the sample chart below.

I would like to do 2 things

How do I create a formula for my chart starting F5 where it will address all of the following conditions and give me the appropriate results and add a color for condition and its matching results in column F:
If C= 4 or 5 and D=4 or 5, then HighImpact-Hard
If C= 1 or 2 and D=4 or 5, then LowImpact-Hard
If C= 4 or 5 and D=1 or 2, then HighImpact-Easy
If C= 1 or 2 and D=1 or 2, then LowImpact-Easy
If C= 3 and D=1 or 2, then NeutralImpact-Easy
If C= 3 and D=4 or 5, then NeutralImpact-hard
If C= 4 or 5 and D=3, then HighImpact-NeutralEffort
If C= 1 or 2 and D=3, then LowImpact-NeutralEffort

Also, to the right of my table B5 to E94 is there a way to create a 4 quadrant plot, where the top left is the highImpact-hard, the bottom left= LowImpact-hard, the top right=highimpact-Easy, the bottom right= lowimpact-Easy and place the cell number in column B that matches the records condition in column C&D into the appropriate quadrant. row 5 is the first record. row 4 is the heading row.

Ideas Impact Effort Total
1) Buy Local and Direct from Producers 5 3 8
2) Share your Knowledge & Enthusiasm for Local Food 3 3 6
3) Join a Community Supported Agriculture (CSA) Program 1 5 6
4) Network Home Gardeners 5 2 7
5) Add Value to Your Own Agricultural Products 4 3 7
6) Identify Opportunities for Local Distribution 5 4 9
7) Find Ways to Pool Resources & Costs with Others 5 3 8
8) Network Community-Based Farmers 5 3 8
9) Create Incentives for Consumers to Shop Locally 5 2 7

 

[dreid1011]

when i click on the button, it just highlights to allow me to change the text, it doesnt execute or run the program

On the Developer tab, is Design Mode selected?

 

[Brew]

Yes, but now the buttons are not clickable

 

[dreid1011]

In order to click the buttons, Design Mode needs to be unselected. Then, you should be able to click the buttons. If not, let me know... I can't think of anything offhand that would be making them not work unless their names changed when you copied the book.

 

[Brew]

Its running now, however, i got a runtime error
Method Range of Object_Worksheet failed
for

Set tB1 = ws.Shapes.AddTextbox(msoTextOrientationHorizontal, Range(yVal(Range("D" & i).Value) & xVal(Range("C" & i).Value)).Offset(3, 1).Left + 16, Range(yVal(Range("D" & i).Value) & xVal(Range("C" & i).Value)).Offset(3, 1).Top + 8, 30, 15)

so only some of the results populated the 4 quadrants.

 

[dreid1011]

Is the book something you could send to me so that I may look at the code? Without seeing it, I'm afraid I not sure exactly why it's getting an error.

 

[Brew]

Yes, i have modified, changed or deleted some of the information, how do i sent it to you

 

[dreid1011]

Yes, i have modified, changed or deleted some of the information, how do i sent it to you

I have sent you a message with my email and an alternative method to send me the file.