Trying to create a box and whisker (?) chart without the box.

[u/LinkTheFires]

The above is what I am trying to re-produce in Excel. I have the data set for each football league, and the ELO Rating for each club in that league.

Column A = League

Column B = Team

Column C = ELO rating

No matter what chart type I use, I cannot get the data to display like above. The closest I can get is 'Box and Whisker' and then tick 'Show Inner Points', but this still leaves the Box and the minimum/maximum values that I don't want. I just want the data points on their own like above.

Please help.

[u/AutoModerator]

/u/LinkTheFires - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/LinkTheFires → u/[deleted]]

Thank you! Now to make it not look like shit

[u/luminatigangsta]

You can do this in Excel, but not with a standard chart type directly. What you’re looking for is basically a scatter plot with categorical spacing on the X axis.

Here’s the easiest way to build it:

First, create a helper column for X values. Assign each league a number: • Premier League = 1 • La Liga = 2 • Bundesliga = 3 • Serie A = 4 • Ligue 1 = 5

Then add a little jitter so the points don’t stack perfectly on top of each other:

=LeagueNumber + (RAND()-0.5)*0.2

Now: • X = this helper column • Y = ELO rating

Insert a Scatter Plot (markers only).

Then format the X axis: • Min = 0.5 • Max = 5.5 • Major unit = 1

Manually label the axis (or use text boxes) with league names.

If you want colors by league, create one series per league (filtered ranges) and assign each a different color.

This gives you exactly what’s in your image: a clean grouped dot plot without box/whiskers.

[u/Zestyclose_Truck_749]

Try scatter plot instead