Thank you vletm - I need to be able to plot this in a 9 grid box not a 4 box grid, and problem is usually the scales are 1 to 3 for both potential and performance. in my case, the company decided to go with a scale of 1 to 4 for performance and 1 to 3 for potential, so I cannot really place the employees properly as it is not 3x3 - it is 4x3. I can say that for performance 1 and 2 should be considered 'low'. However, I also have an issue with placing because when let's say someone is at 1 potential and 1 performance, they would not be visible in the grid - I think in some cases there is a calibration such as multiplying both sides by a coefficient but not sure how to do it when scales are different...Thanks so much for any ideas you may have
vletm thank you very much for your help. Actually I solved the problem of the 4 and 3 so now I only have 3 and 3. The problem is though what I described in my previous note - the calculation seems to be wrong as some values go over 3 and thus are not plotted in the 9 box - do you know a fix for this issue? thanks again!danagsf
the potential is evaluated on a scale of 1-3 and the performance on a scale of 1 to 4
if potential is 2 and performance is 3 ... total 5 (if no take care of scale)
if only notice value 5 could plot in many possible 'boxes'
... because potential could be 1-4 and performance could be 1-4 ( but total value max 5)
( eg potential = 1 and performance = 4 or potential = 4 and performance = 1 ... plots in different 'box' )
refer to Your used Excel-file as in #8 Reply.
... You should give those values with Excel-file!
I do read messages - it is not what I was asking. The question is more complex and the attached did not solve the issue, but thanks anyway for your help. I will not take any more of the time of this forum. Regards