Add vertical / horizontal line to chart created with VBA

[pp57]

In another thread (https://www.excelforum.com/excel-pro...y-columns.html) I asked for advice on adding one series at a time to a chart created in VBA.

Now I would like to add a horizontal (and eventually vertical) line to the chart. The existing code is:

Please Login or Register  to view this content.

How could I then add a horizontal line to the chart where the two y values are just the value stored in a single cell F1, the initial x value is 0 and the final x value is in cell F2?

I've been trying to use a similar setup to the code above however I can't figure out how to add single x or y values to the series collection. I'm trying to avoid having to explicitly store x and y values in adjacent cells, especially since for the horizontal line the y values are simply the repetition of a single number.

[MrShorty]

How about using error bar(s). Instead of adding a new series consisting of two data points, add a new series consisting of a single X,Y data point, then add a horizontal error bar to that data point with the desired length. https://msdn.microsoft.com/en-us/lib.../ff821924.aspx