Production charting

Bgears06

New Member
Joined
Dec 21, 2018
Messages
1
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.
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,402
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
 

Forum statistics

Threads
1,085,546
Messages
5,384,374
Members
401,890
Latest member
Angela7

Some videos you may like

This Week's Hot Topics

Top