Color columns according to a condition

So I have a column chart. The Y axis is a simple time series. The X axis has column labels with say the following names - 1abc, 2def,  1tyu, 2hjk , 1osa, 2rty. So essentially a number and a string together. I WANT these labels to show up on the X axis. However I was wondering while coloring if I could have a specific coloring for the columns which have “1” in them. and another for “2”. So 1abc, 1tyu, 1osa will have blue color. And 2def, 2hjk and 2rty will have green color. Is it possible?

0 0 64
0 REPLIES 0
Top Labels in this Space
Top Solution Authors