For an admin panel I have to present visually the employees' test scores and after lots of searching to decide which data visualization is the best I decided to choose the vertical bar chart but as the number of employees can increase up to more than 50 I can not use the vertical bar chart so I change it to horizontal one but the problem is it gets too long and the admin has to scroll down to see all the employees' score and can't make a good comparison of all the scores. So can anyone help me with how can I show all scores in one visual element without too much scrolling?
Think about what the real task of the admin is here
the admin has to scroll down to see all the employees' score and can't make a good comparison of all the scores.
Space will almost always be an issue in most UI (what happens when it's 100 employees?). What you could do, is use a kind of search and filter, where you could pull up a number of employees at once.
It seems like the core task is comparison and finding employees to see where they sit on the chart.
If I have 50 employees, I can't compare all 50 at once (especially if I'm looking around for several at a time, and I have to keep scanning up and down the list), but I might have several I wish to compare (or a team), but each sits at different positions in the ranking order.
Here's a rough sketch of an idea:
A lot of data visualization and dashboards uses a pattern of getting the big picture first (the larger graph), then drilling into details (filtering).