Hi prasaddn,
You could do it this way.
Assume your data is in Column A, B and C in the order that you listed.
Sort the Empl Names in alphabetical order A-Z (optional)
In Cell E2 type in the job level that you want to return the top 10 employees.
Cell F2...
Hi justdream,
It will require VBA and the chart will need to be on a chart sheet (otherwise more coding will be necessary). This code should get you started. Create a chart sheet for your chart, right click the tab and select view code. Paste this into the right:
Option Explicit
Private...