I can add data labels to all points on a line. Can I, and how, add one data label to the end point of the line?
The key is to select a single point. Try clicking on the point a few times until it gets selected. Then right-click on the point and choose Insert Single Data Label.
Thanks, Jim. But regret it does not work for me. I’m using LO v.5.1.4.2 which is the latest. Also use stepped line. Though I’ve found a way around! Click on ‘Chart Type’ and change to ‘Columns’. Select last column and click. Select ‘Insert Single Data Label’ enter label details. Label appears with last column. Click ‘Chart Type’ and change back to ‘Stepped Line’. There is the label by the last point!
Christopher W.
You now have enough points to edit the question and attach an example file. Or, if you are happy with the Columns workaround, then post it as an answer and mark it as correct to close out the question.
I’m using LO v.5.1.4.2 which is the latest. Also use stepped line. Though I’ve found a way around! Click on ‘Chart Type’ and change to ‘Columns’. Select last column and click. Select ‘Insert Single Data Label’ enter label details. Label appears with last column. Click ‘Chart Type’ and change back to ‘Stepped Line’. There is the label by the last point!
1 Like
Still relevant in 2023, the only way I have found to do this is to add to the labels to the line - which adds it to all points - then manually delete each label except the last one.
It can be time consuming but gets what the OP is asking for and something I use a lot. One day I’ll get around to writing a macro. Until then…
- Double Click the Chart
- Select the first line
- Right-click->Insert Data Labels
- Double click on any data label->choose type (in my case “Series Name”)
- Click Ok
- Click each data label you don’t want. Press ‘Delete’ on keyboard.
- Repeat
- Move remaining labels to desired position by clicking on then (selecting) then click&drag to position
Here’s my example:
Using LO v.7.5.6.2 Community
2 Likes