Chart point color based label - It is possible ? (VBA)

[rodrigo_m_almeida]

Good afternoon,
Could someone help me with this ?
I'm trying to color the columns (points) of my graph based on the labels
Does anyone know how to do

If label equals "seg" green column
If label equals "sex" yellow column

my chart is powered by pivot table

 

[ekrause]

Yes, you can do it - but not in the graph itself. You need to reformat your table and add extra rows/columns for seg & sex Items.

Color 2 (seg) formula =IF(C3="seg",C4,0)
Color 3 (sex) formula =IF(C3="sex",C4,0)

Insert a Stacked Column Chart and format as needed from there.