I have a column chat that plots some positive and negative values. I would like for the positive columns to be one color and for the negative once a different color. Normally i would acomplish this by having 2 separate data sets one for the positive values and one for the negative once and then setting the color for them separately. My data however is pretty large at this point so i started to use a pivot table and i can either plot the pos values or the neg or all and all the columns are the same color. Does anyone know of a way to acomplish this?