I've got a graph that was generated from a data set that contains:
(date, value, annotation)
The annotation is a constant value [its either there or is blank] and I would like to add in the third bit of data into the graph I have. An example of this is in the image. The blue line is a graph of the (date, value) graph, and I would like to add in the red dots as graphing (date, annotation@value).
Is there an easy way to do this in excel, without having to modify the appearance of the data?