将列中的列颜色链接到工作表中的范围

I have a range next to data area of the column-chart. I have to relate each column's color of the chart with this range. E.g. if there is "X" in the table, so the chart-column ralated to this row would be red, else green.I have a range next to data area of the column-