• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi Level Charting

Brisbane Bob

New Member
This looks so easy and it probably is but I can't get it.


How do you chart (probably using stcked bar or column) the following matrix:


Team 1 Player 1 25 103 14 122 16 119

Player 2 11 106 15 108 24 110

Player 3 10 104 12 113 17 111

Player 4 24 107 12 108 17 100

Player 5 21 115 20 102 16 125

Player 6 12 123 18 114 13 111

Player 7 20 114 20 112 21 104

Player 8 14 105 13 100 19 120

Player 9 10 115 24 123 21 120

Player 10 22 125 10 122 24 103

Team 2 Player 1 23 122 10 112 20 114

Player 2 15 106 17 122 20 121

Player 3 18 107 17 109 19 123

Data1 Data2 Data3 Data4 Data5 Data6

Period 1 Period 2 Period 3


I can't even get close. ANyone have any ideas?
 

Hui

Excel Ninja
Staff member
Bob

A few questions

Are the different columns for each player Periods or Events ?


You need to work out what you want to see

Do you want to see:

Team 1 analysis, Player 1 vs Player 2 over time

Team analysis, Team 1 Player 1 vs Team 2 Player 2 over time etc

Team analysis, Team 1 Player 1 vs Team 2 Player 2 at a given time

etc


Do you want a one off chart or do you want it interactive allowing you to choose the data you see, Team, player, Periods etc
 
Top