I have a table of production and I would like to be able to show one person how they compare to other doing they same work without showing the other names. For example: steve compare to person 1, 2 ,3 and mary person 1,2,3 without making a separate table for each person.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
NdNoviceHlp
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 3,752
Hi Bgears06 and Welcome to the Board. In column A, place your X values, In column B, place your average values. In column C, place your "steve or mary" values. Scatter Chart the 3 columns. It should produce a chart with 2 series, series 1 being the average, series 2 being the employee being compared to the average. HTH. Dave
Upvote
0
