Draw 3 points with 2 limit lines on a graph

After a day, I will proffer a few thoughts:

This forum can be strict about rules (including putting code tags around code). You will want to edit your post to include these code tags to avoid having your topic locked https://www.excelforum.com/misc.php?do=bbcode#code

Since you say you are new to VBA graphing, I will suggest this help file: https://msdn.microsoft.com/VBA/Excel...s-object-excel I found that one of the things that really helped me early on was becoming familiar with Excel's object model (and the accompanying object, properties, and methods), as well as the help files that document the object model (Microsoft has never been excellent at putting help files together, but I found them helpful once I figure out how to use them more effectively). The linked file is to the series object help file, which includes links to the properties that apply to the series object, including the .xvalues property, the .values property (which should show you how to use a range instead of an array constant to define these), the .markerstyle property, and the .markersize property (which should explain how to change the size of the marker).

I need the three markers on one X value, but different Y values.

When I tested your code (adapted to the test sheet I created), this is what I got. I got three new data series, two points for each new series, and three points at each of the specified X values. I am not sure I understand your question here, though, since the code is syntactically correct, I wonder if this part of your question is more about the logic behind the programming rather than the programming itself.

If this is not what you wanted, perhaps you were looking to add a single data series consisting of three points? Perhaps you were looking for

Please Login or Register  to view this content.

or perhaps 3 single point data series with a single point each?

Please Login or Register  to view this content.

Or something else?