My expertise with Excel is very limited. I already have a chart created for what I would like to do; however, it's very "primitive and crude" compared to other super advanced spreadsheets I have seen before.
The chart I am trying to make is a comparison between several teams. Each team has a final score as well as scores in several sub-captions. I would like to be able to easily sort the chart by individual sub-captions or final score.
The data (Scores/Ratings) will be entered manually. In additon, each individual score is color coded and ranked. Again, I am not experienced with Excel so my description is probably confusing.
I will include a file with what I've already made. I am just looking to make it more intuitive and easy to sort.
In addition, if there is anyone that can help with publishing an interactive chart online with the same information will be considered as well.