Grouping data in clustered column chart

For someone new to charting in Excel, I would emphasize that charts do not analyze data, they only show what is already in the spreadsheet. If I am understanding your pictures, you have a table/database showing name, level, and score. You want to get a count of how many people of each level had a certain score, and show that on a chart. Before you can create the chart, you will need to have the spreadsheet calculate the appropriate counts and other summary data. If you arrange this summary table well, then creating the chart should be straightforward.

Are you already able to summarize the data (whether using a pivot table or a COUNTIFS() function or similar), or will you need help with the spreadsheet part of the problem, too?

Hello,

what you have mocked up looks like a clustered stacked column chart, only there is nothing stacked. It is not in Excel's native offerings, but with some careful data arrangement and a few charting tricks it can be done. Jon Peltier has an article about the technique here:
https://peltiertech.com/clustered-st...mn-bar-charts/

cheers, teylyn

Perhaps, though this is also the subforum for pivot tables, too, and a pivot table might be the easiest way to perform the desired analysis. Intro to pivot tables: https://www.excel-easy.com/data-****...ot-tables.html

For example, based on your simple table in the first picture, I could create a pivot table using score as the row labels, level as the column labels, and count of ID as the pivot table values. Then I could create a pivot chart from the pivot table and I should get something really close to the chart you show in the second picture.

If your real data is more extensive and/or your real analysis is going to be more complex, a pivot table with slicers and filters and the other tools that come with pivot tables may be a useful way to analyze your data.