Plot a AREA in a X,Y scatter plot

[b_rianv]

Good evening all,

Can you plot a area in a x, y scatter plot?

If you look at my "Plot AREA" table I would like to draw lines connecting these points from this table in the chart once I input data and then click my Plot area button. So it would draw lines to connect these X, Y points.
Can this be done and can someone help me do this?

Thank you,
Brian

[b_rianv]

I hope someone can help.
Also if you don't see my table it is in cells Y - ASAP and yellow.
Thank you for your time

[b_rianv]

Cells Y2 - AA2
I colored it yellow.

[Kenneth Hobs]

I am not sure why your cross-posted. http://www.excelforum.com/excel-programming-vba-macros/1159508-plot-a-area-in-a-x-y-scatter-plot.html

I guess you don't know how to do it manually? I took me about 25 seconds...


Insert > Scatter > Scatter with Straight Lines and Markers
Select Data > Add > select 2nd and 3rd boxes to mouse drag and select the ranges for Series x & y Values > OK > OK