1. Divides a data series into two series. One column is lower than your required value, and the other column is higher than your required value. These two sequences are referenced in the chart, and different colors are set respectively.

2. Double-click the column chart to change the color, then select the color and confirm.

3. I don't know if you have used the theme function in 2007, so you can adjust the color matching of the chart in a unified way.

4. use VBA. If it is tabular data, it can be set with offset plus conditional format.

5, the last one:

The following table is an independent bar chart. When you have entered all the data as required, click the specific reference on the menu bar:

/question/550 168325.html？ qbl = relate _ question _ 1 & amp； word = EXCEL % D6 % F9 % D0 % CE % CD % BC % D3 % C3 % B9 % AB % CA % BD % CB % E6 % CA % FD % D6 % B5 % B6 % F8 % B8 % C4 % b 1% E4 % d 1% D5 % C9 % AB % 2C

Please adopt ~ ~ ~ if you are satisfied.