Manojlo
New Member
- Joined
- Sep 4, 2020
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hello
Is there any options to add specific color for single bar in chart, and bar to keep this color when change position in chart.
For Example if we have two columns A i B, in A column (from A2:A5) we have words: Red, Blue, White, Yellow and Green, and in B column we have some values: 10, 20, 30, 40 and 50.
We make Clustered column chart in descending order, for example Green cell is on first place and have value 50, and I want to make this bar in green color even if I change values, for example 10 and it is not on first place anymore
Is there any options to add specific color for single bar in chart, and bar to keep this color when change position in chart.
For Example if we have two columns A i B, in A column (from A2:A5) we have words: Red, Blue, White, Yellow and Green, and in B column we have some values: 10, 20, 30, 40 and 50.
We make Clustered column chart in descending order, for example Green cell is on first place and have value 50, and I want to make this bar in green color even if I change values, for example 10 and it is not on first place anymore