I have a spreadsheet that shows 6 managers evaluation score for separate questions.
Those scores are averaged together for a final tally. (in cell K39)
I would like for that final tally to show in a graph ranging from Low to High.
The rating range is
4.5 - 5= significantly exceeds expectations (HIGH)
3.5 – 4.49 = exceeds expectations
2.5 – 3.49 = meets expectations
1.5 – 2.49 = Development Needed
1 – 1.49 = critical deficiency (LOW)
F________G__________H_________I_________J
Low <---------------------------------> High
XXXX
_________XXXX
___________________XXXXXX
_____________________________XXXXXX
_______________________________________XXXX
I was hoping some kind of an "if/then/else" statement? But I cant get the formula to work. This is to show at a glance where they are in the range.
So you dont see the number 2.45 and have to look at the chart reference.
Any help or guidance would be greatly appreciated!
Bookmarks