How to show the midpoint/median in a line chart

[LWLS]

Hi Everyone

In the attached spreadsheet, is there a way I could indicate the month of MAY as the median/midpoint. My aim is to show the trend before and after the month of MAY.


Many thanks for your assistance.

[Andy Pope]

You can use a dummy series with an plus Y error bar.
You will need to fix the secondary axis min/max values if you want the line to go from top to bottom of plot area

[LWLS]

Thanks Andy. Much appreciated.