In my pivot chart I have the seven days of the week on the x-axis and each day of the week has three bars to represent three different work shifts (refer to attachment).
I don't see a way to change the colors for the bars that correspond to each shift. For example, I would like 1st shift to be represented by blue, 2nd shift to be green, and 3rd shift to be yellow. And each time I update the pivot table with more data the bars in the pivot chart will remain colored when I refresh.
Is this possible?
Bookmarks