Trying to add events

[ghellers]

Ok so I have a set of data and I am trying to add an event, now I have tried 2 ways. The first way plots the events nicely but adds a 0 along my entire x-axis.

And my second way is me manually deleting those zeros but then it does not work.

Can someone have a look at my spreadsheet please and try and see where I have gone wrong.

Or if there is a more efficient way of adding a single ponit/event onto a chart then please let me know.

Thanks

data.xlsx

[Andy Pope]

Change the formula to use NA() instead of "", as "" is treated in the chart as text and text is plotted as zero.

=IF(F$1=$A3,MAX(B3:D196),NA())

Add 100% minus error bar to the event series. remove line format, apply data marker if helpful.