I have a table of 64 cells containing numbers. I make a bar chart in excel with the numbers listed from high to low. I want to make the first set of 21 bars green, the second set of 21 bars yellow, the third set of 21 bars red. I had to select each bar manually to do this and I have 20 of these charts to make.
Is there an easier way to change the bar color for a set of cells?
Solved by Z. E. in 13 mins