Chart suggestions, many points

[smudgepost]

Hi all, I was playing with a radar/spider diagram as I have about 10 points to chart for a company and I want to do an overlap of year 1 and year 2 so a radar is perfect. However, I have to do this for about 8 companies and realised this could look very messy in a radar chart. I'm trying to avoid one per company, see if I can present all of the data in one tidy dashboard, any suggestions?

The data is simple, little more than:

Company 1|Year 1|Year 2
Category 1|9|7
Category 2|6|10
Category 3|5|1
Category 4|6|4
Category 5|9|3
Category 6|7|1
Category 7|1|2
Category 8|1|7
Category 9|5|4
Category 10|7|3

[alexander.small]

Have you tried the pivot table function?

[alexander.small]

Based on what you've said I think this would be helpful. It would be easier if you uploaded a sample workbook though.

I hope this helps.

[Andy Pope]

Use a bar chart and overlay periods.

You could also include some GUI element to select which company to display or compare.

Possible rank categories if that makes sense to do so.

[smudgepost]

Excellent examples, thank you Andy and Alexander! Both may be very useful in my 'dashboard'. Thanks again!

[alexander.small]

Excellent examples, thank you Andy and Alexander! Both may be very useful in my 'dashboard'. Thanks again!

Not a problem! If our answers helped could you please Add Reputation, and also mark the thread as solved please, thanks!