Scatter chart, how to do it and add a line ?

[fredericvillemi]

Hello,

I thought I could easily make a Scatter chart and I don't really find how to do what i want to do.

I have a Size, a Price and many points.

How can I create my Scatter to have Sizes as x, prices as y and have all the points as + like on this graph ?

And how can I add a blue curve on the scatter ? i presume it's impossible to do but if you have tips on how you would do that, i would be really happy

Thanks

[dsharmaqv · Accepted solution]

You should read this

Creating a Scatter Chart

[dsharmaqv]

Also can you explain what that line is ..... avg or what ...... We can create trend line as well

[fredericvillemi]

Thanks for your link, that's really useful.

About the line, it is based on some of the data which appear on the scatter but with complicated calculation done before. Not one of the trendline available in the scatter expression dialog...

[dsharmaqv]

try this thread

Combined Line/Scatter Chart

Mark helpful if it resolve your query

[fredericvillemi]

Thanks, I think it's the best answer i can find !