Insert line in graph with macro

[elbartje]

I want to insert a line in a graph the x en y data needs to come from an userform (an input box is also ok).
I dont want to select a range of cells but directly enter a value(s) for the x and y data.
This data should not be put in cells but only in the graph itself

So I select a graph, run the macro I get a popup to enter x and y data for example X1=0 X2=10 and Y1=120 and Y2=120.
Now a horizontal line is plotted in the graph.

 

[RickXL]

Good news, thanks for letting me know.

Regards,

 

[Vfriendsp]

I just had to add an extra graph in the main graph with 2 points on y axis, then change type of graph so it becomes a straight horizontal line, then change data source for x axis so it becomes a vertical line.