Home

Change Series Fill Colour for 100% Stacked Column Chart

punithadrk
Occasional Visitor

Hi,

 

Someone created a 100% stacked chart for me, and it is working. Now, I would like to change the colour for Series 2 of the chart to pink , as in the colour for completed task box (please refer to the attachment). I tried everything I can think of from the chart format ribbon to no avail. Please help.

 

Thank you so much for your expertise,

punitha drk

1 Reply

select the seris, right click and select format data series. On Excel 2013 and later there will be a new window opened on the right of the screen select the first icon on the top.From there fill-->solid fill and select the color. However in your graph the series is wider and need to increase the gap.