[SOLVED] Add secondary Y axis in middle of chart

Hi all;

I would like to add a secondary Y axis to a chart; I have followed instructions from other sites, which is:
r-click on chart
choose “Insert/Delete axes”
select “Secondary Y axis”
r-click on secondary axis, select “Format axis”, select “Positioning”, select “Category”, select desired position for vertical line

The problem is that the secondary axis will only appear on the left or the right of the graph - never in the middle.

The chart consists of three columns: dates (yyyy-mm-dd) and two columns of numbers

I need a vertical line to appear at a specific date to highlight a change in behaviour.

I would be most grateful for a solution!


Please remove “[SOLVED]” from the question; the answer that is marked correct shows your question has been answered satisfactorily.

If you use a x-y-scatter chart with the dates as x-axis then you can select a value instead of a cathegory.

@MarcB – please mark horst’s Answer as correct.

Perfect! Thanks a ton, Horst! While having the old functionality back in the line chart would have been nice, this does exactly what I need it to do!

Thanks again!


You are right it is a little drawback:(

Could you move this “answer” to the comments of the accepted answer?