I am making a number of standard, basic bar/column charts which are showing the rank of certain areas against a number of questions. Each graph will have their own tab as they will be getting exported at some point into a separate report.
I have 4 areas, A - D and I want to keep the colour of each area consistent across the charts, and the charts are to be shown by rank of score for each question.
So for question 1 lets assume the rank is A, B, C, D and I assign the colours red, blue, green yellow.
If on question 2 the rank is B, D, C, A is there any way to assign A to still be red for consistency between the charts without having to manually set them all on each chart?
I have 4 areas, A - D and I want to keep the colour of each area consistent across the charts, and the charts are to be shown by rank of score for each question.
So for question 1 lets assume the rank is A, B, C, D and I assign the colours red, blue, green yellow.
If on question 2 the rank is B, D, C, A is there any way to assign A to still be red for consistency between the charts without having to manually set them all on each chart?