Calculating average in weekly reporting of count of examinations
I try to calculate the average of the count of examinations in our radiology department on a weekly basis.
So I would like to show the count of examinations for each week with a bar chart. The weekly average of these examinations/week should be shown as a horizontal line.
I know, that I can use the standard function "Average" (see screenshot, green markers). But my problem is, that I want to use specific colors for the different years (dark blue for current year, light blue for previous year, different shades of grey for older years). I can set these colors for the bar chart, but for the average line QV sets the color automatically. So I have different colors for the bars and the average line for e.g. the year 2015.
Does anybody have a good idea to solve this problem.