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.
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.