I have this chart (see picture). I want to display on the red dotted line values as well, e.g 5 and 6 in this case (5 above the bar with 5 in it and 6 above the bar with the 6 on it). I was able to display 5 and 6 in the bars, but I can't do it on the line as well.
My table is like this:
Name Target Achieved
A 1 1
B 1 1
C 1 0
Thank you so much,
PS: No scripts please, I have the free version so I cannot open them
If the dotted line is a reference line created on the Presentation tab then you cannot show values on it, only one label is possible. If your chart is a combo chart and the line an expression displayed as line then you should be able to display the values on the line too by enabling the Values on Data Points option for the line expression.