Data Sorting on Excel Charts
Solved
vince3457
Posted messages
36
Status
Membre
-
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Hello,
Here is my issue,
I have different services
in each service, I have teams of people.
for each team, I have numeric tracking.
I sort this numeric data globally.
So I have several horizontal bars in descending order on my graph. (1 bar per team).
The problem is that I would like the bars of a service to be the same color, but if I assign a color to a data point, if the values change and the sorting is updated... the data points (bars) "move" but the colors do not...
Can we make it so that if I say that the data bar for team EF is green, even if it moves in the sort (and therefore on the graph), it stays green?
Thank you in advance.
ps: I am using Excel 2010
Configuration: Windows 7 / Internet Explorer 8.0
Here is my issue,
I have different services
in each service, I have teams of people.
for each team, I have numeric tracking.
I sort this numeric data globally.
So I have several horizontal bars in descending order on my graph. (1 bar per team).
The problem is that I would like the bars of a service to be the same color, but if I assign a color to a data point, if the values change and the sorting is updated... the data points (bars) "move" but the colors do not...
Can we make it so that if I say that the data bar for team EF is green, even if it moves in the sort (and therefore on the graph), it stays green?
Thank you in advance.
ps: I am using Excel 2010
Configuration: Windows 7 / Internet Explorer 8.0
