1 of 1 people found this helpful
This sounds like a classic example of a scatter plot. Put Number of Widgets Built on the y-axis, and then put the Defect rate on the x-axis. Then put Employee ID on the Detail shelf. That will show you the all-time most successful widget makers.
Then you can put the Date filter on the filter shelf set to month. This will show you how different Employees are doing over each month. If you put it on the page shelf you can quickly move through the months.
But ultimately it sounds like you are really wanting to know who builds the most defective-free widgets at the highest rate of speed. Now that's one of those questions that will require a bit of mocked up data in a packaged workbook to answer.
But anyway my best advice is to think outside the bar-chart-box.