Hi
I have a sheet in which records for different players in different teams are added

4 teams
And multiple players.. around 40 players total

When i make the pivot chart to show the records for all players, im trying to give each player bar a color depending on player's team name
Is there a way to do that automatically?

For example
Blue teamp player: blue bar
Red team player: red bar
Orange team player: orange bar
Etc

The thing is that the data sorting is changed all the time from top to bottom record
And if i color bars manually, the color remain on bars regardless of player name on that bar