Forum Discussion
Add Annotation to Graph Data Point
Data labels are the only way of consistently adding information to chart points, but they always apply to a chart series as a whole, not to individual points.
Okay, so I select all the data points my series that I want to annotate, and when I right-click I get this image. I don't see an annotation option there?
Formatting menus for a chart are contextual based on what is active.
I recommend using this drop down to view what you have active:1-click selects the series. 2 clicks selects a data point and from there you add a single data label.
There is no annotation option in the sense that you want.
You have selected the data labels.
Select 'Format Data Labels' from the context menu to activate the task pane of the same name:
You can enter the annotations that you want in a range of cells, then select 'Value From Cells' in the task pane and point to that range.
For example: