Simple Bar Chart with Bar Colors Based on Values?

[slam]

I have a simple bar chart based on two columns, with a person's name in Column A, and a % for them in column D. Works well.

I want to color code the bars based on their % as follows:

0-10% = Green
11-20% = Yellow
> 20% = Red

Is this possible with Excel 365?

Thanks!

 

[kevin9999]

It is possible, but as far as I know - and I'm happy to be corrected - the only way is to have 3 different series on your chart, and format them individually. In your case, you would create 3 x columns with formulas to determine whether to show the respective percentages, or leave blank, then format the series individually.

Bar Chart.xlsx
	A	B	C	D	E	F	G
1	Name			Percentage	0-10	11-20	20+
2	Adam			2%	2%
3	Andrea			4%	4%
4	Bob			8%	8%
5	Barbara			12%		12%
6	Chris			14%		14%
7	Colette			2%	2%
8	Dave			18%		18%
9	Dawn			20%		20%
10	Eric			22%			22%
11	Eve			24%			24%
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=IF(D2<=0.1,D2,"")
F2:F11	F2	=IF(AND(D2>0.11,D2<=0.2),D2,"")
G2:G11	G2	=IF(D2>0.2,D2,"")

 

[slam]

Thank you, Kevin. That makes sense, I will give it a try soon.