Excel Graph Help: Plotting Experimental Data with Theoretical Model in One Graph

[dRic2]

I have a set of n point (x, y) of experimental data and a function y=f(x) which is the theoretical model. I want to plot them in the same graph and see the difference. My problem is that f(x) has to be a continuous line while my n point has be just dots. I need to get something like this:

I don't know how to plot dots and line simultaneously. Can anybody help me?

 

[berkeman]

In the Excel "Insert" tab, try Scatter Plot, and choose what kind of lines you want to connect your dots with...

 

[gmax137]

Yes you can format each data series individually, so use
"Marker Options = Automatic" and "Line Color = no line" for the recorded data, and
"Marker Options = No marker" for the function.

 

[dRic2]

How do I use Marker Options ? I'm not very good with excel

 

[dRic2]

OK I did it. Thank you very much!

 

[gmax137]

wow that was quick ! I hope it looks as you wanted.

 

[dRic2]

Ahahahah I tried with some random numbers. Now I'm going to do the real stuff ;)