Change colours in stacked column chart

Hi TonyG,

Don't know ig you are using a chart with or without drill down however it's possible to do it in the both situations if you select the chart and on the Data Colors you select the Show all you can select a color for each specific column, when in a drill down situation you need to select the first level and change the colour then second level and change colour and so on.

Check this prints below, as you can see if you select the drill down option on the first year then you only get the formatting options for the months in that year the other months in other years keep the same.

Regards,

MFelix

HI TonyG,

You can drag the colored column to legend, it will auto change these bars to different colors.

Notice: if you use legend field, then you can't drag multiple columns to value fields.

Regards,

Xiaoxin Sheng

Hi,

Thanks for answering my question.

I have tested it but it doesn't work with a stacked column chart :smileysad: 

Is it possible to change the data colors also with a stacked column chart??

Greetz Tony.

You can go to colors and select each value and color you want for legend.

If you select your chart and go to themes, you can select custom themes and then change your colors.