How do you fill the area under an X-Y scatter chart?

I have a X-Y scatter graph and I want to fill in the area underneath the line. Is this possible?

I have attached the chart.

many thanks in advance.

combine it with an area chart, using the same data points. See attached.

Originally Posted by npamcpp

combine it with an area chart, using the same data points. See attached.

Originally Posted by npamcpp

combine it with an area chart, using the same data points. See attached.

Sorry my problem seems to be a bit more difficult becuase I am already useing a mixed chart. I have a curved with should commence area the righthand side of the lower step of the graph. The curve reaches 0 on the y-axis are approx x=35-40ish.

When I put in the area data, it does not go under the scatter line in goes under the curve and also now displays the wrong access data. I want it to display the curve x-axis.

See attached image of resultant graph

A picture is not helpful.

I used the data in your first attachment. If your real data and chart differs, then post that.

Originally Posted by npamcpp

A picture is not helpful.

I used the data in your first attachment. If your real data and chart differs, then post that.

Please see attached data file.

Hmm,

this is a rather unfortunate data layout. Normally the X data would be listed to the left of the Y data, but that's not the problem. I can create an area chart under one of each data series, but not both.

Maybe Andy has some ideas.

see attached.

Originally Posted by npamcpp

Hmm,

this is a rather unfortunate data layout. Normally the X data would be listed to the left of the Y data, but that's not the problem. I can create an area chart under one of each data series, but not both.

Maybe Andy has some ideas.

see attached.

My Apologies for the layout - it took me about 20 mins to strip out all of the private data and that is what I was left with as a result.

You graph on the right is what i am trying to achieve acept fot some some reason the lower portion of the curve is now missing?

Originally Posted by Andy Pope

As per my previous description.

Thank you this produces the correct result. However, at the risk of appearing extremely stupid, I do not understand how? I do not understannd the 500 etc values you have generated to produce this result?

Many thanks again.

Andy, is it possible to create areas below both the yellow and the lines?

Hello zigor, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.