If those lines are series then select line data point in the line and apply data label. If not then add some additional series and use those to display required information.
You can use this free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm
Post example workbook, rather than image, if you need more help
Here is the Worksheet. It was generated using my VBA code. I just need to add the labels to those specific series...
Thanx for helping
Regards,
B
To apply label to existing line series select the series and then use the right arrow to scroll through the data points. When the last point is selected apply data labels.
I have done both Series Name and Y value labels.
Or you can add another series, I did one for "-3s" which has no values expect for last data point. You can then apply data labels to whole series but only last data point will be displayed.
FANTASTIC !!!!
Thanx SO much)
@ puffin617
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Thanx... Will remember that in the future
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks