Dec 07 2018 12:40 AM
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
Dec 07 2018 01:28 AM
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.