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.
I've attached the qvw and the excel I've used. Take a look over it, please and let me know what should I change so the values are displayed on the dotted line as well.
Try not to send it back, because I wouldn't be able to open it.
The reason you don't see any values on the line is because the axis ends at 100%. There's no room to display the values. If you set the max to 1.05 you'll see the values.
That looks good, but instead of 100%, how can I display 5 and 6 on the line? At this stage I have 100% and 100% but I need the integer 5 and 6.
Thanks you so much for your time