I am trying to create a column chart that uses 3 different series titles but share the same horizontal values. For example I have a list of tickers from Bloomberg and each has a corresponding % change. What I have done is created a column chart with one series called MTD change and it lists each product on the horizontal axis with the % change as each column. Now I was wondering how I could format this so that all of the equity products are one color column all of the commodity products are a different color colum and the FX products a third color. so no matter what order the colums on the chart appear (I am listening them from lowest to highest change) the corresponding bar always matches the color of its group. I am trying to explain this the best I can, I hope it makes sense and someone can help me out. Thanks.