Help getting Illustrator radar graph tool to behave the same as the Excel one

[lyndsey9dots]

Hi all! I have a specific problem with the radar graph toll in Illustrator and I'm hoping there's an expert in here that will know how to get it to behave the way I need it to.

I have been given a radar graph (and assocated data) in Excel. I need to replicate it in Illustrator. The problem I'm having is, when I input the data I can't get the Illustrator graph to look the same as the Excel one....and it needs to.

Attached screenshot of the Excel version:

Close up of the graph:

The data it is using is the one shown in the row "unweighted average score".

And screenshots of the kind of results I'm getting in Illustrator:

Does anyone know how I should be inputting this data into Illustrator in order to replicate the Excel version? Is it even possible? I really want to avoid doing this manually if I can (as it's something they'll need changing in future, so it would be great if I could just edit the data!)

[Monika Gause]

The Excel graph seems to use a lot more data points. Where are the numbers for that?

[lyndsey9dots]

When I click on the chart in Excel it highlights the bottom row of data (see attached screenshot). So I assume that's the data it is using. That's the same data I've been trying to input in different manners in order to replicate the same results. But I can't get it looking the same.

[Monika Gause]

Obviously in Excel you can group the data. That is not possible in Illustrator.