Make bars on bar graph change color if limit passed

[aragon123321]

Is there any type of Macro or way in excel that can make a single bar on a bar graph change colors if it is passed a certain limit.

Right now my bar graph has data that is automatically updated every 10 minutes. Can we get it for a bar to change colors when a value in the range of where it is getting its data passes the value of another cell.

Thank you so much if anyone has any help to do this. I have excel 2010.

 

[RickXL]

Hi,
You can do it like this.

I created two extra columns which I was going to put on the chart. One column has the values from the original series below the limit and the other has the data values above the limit. I then used a stacked bar chart to display both columns.

The data looked like this:

Excel 2013
	A	B	C
1	Data	OK	Over
2	0.821783	#N/A	0.821783
3	0.522067	0.522067	#N/A
4	0.061891	0.061891	#N/A
5	0.046292	0.046292	#N/A
6	0.671042	0.671042	#N/A
7	0.702608	0.702608	#N/A
8	0.836882	#N/A	0.836882
9	0.115555	0.115555	#N/A
10	0.092779	0.092779	#N/A
11	0.808828	#N/A	0.808828
Sheet1

Cell Formulas
Range	Formula
A2	=RAND()
B2	=IF(A2<0.8,A2,NA())
C2	=IF(A2>=0.8,A2,NA())

Columns OK and Over are the ones on my chart. The #N/A values do not display and the two columns each have their own colour settings.