Jul 22 2022 07:28 PM
On an Excel time graph, how do I add an annotation on a single data point? At the place where the orange line becomes flat below, the temperature of a fermentation changed. So I want to document that.
Jul 22 2022 08:27 PM
@Detlef_Lewin When I follow those directions I get this menu. I don't see any option to add a label.
Jul 26 2022 11:40 AM
Jul 26 2022 11:48 AM
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.
Jul 26 2022 01:08 PM
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?
Jul 26 2022 01:21 PM
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:
Jul 26 2022 01:27 PM
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.