Jim S wrote:
I would like to have graph change color when data exceeds a set value. Anyone
know how to do this?

Here's a simple example of one way to do this.

In column A enter some values to plot:
1
5
31
15
20
12

In column C enter some category labels:
a
b
c
d
e
f

In column D enter this formula and fill down:
=IF(A1<20,A1,NA())

In column E enter this formula and fill down:
=IF(ISNA(D1),A1,NA())

Now select C1:E6 and create a /stacked/ column chart.

What is happening is the values are separated to different series by way
of the formulas in D and E. Since they are different series, they can be
colored differently.