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

  • Thread starter Thread starter dRic2
  • Start date Start date
  • Tags Tags
    Excel Graph
Click For Summary

Discussion Overview

The discussion revolves around plotting experimental data alongside a theoretical model in Excel. Participants seek to understand how to represent discrete data points and a continuous function on the same graph.

Discussion Character

  • Technical explanation, Homework-related

Main Points Raised

  • One participant describes the need to plot experimental data as discrete points and a theoretical model as a continuous line.
  • Another participant suggests using the Scatter Plot option in Excel to achieve the desired graph format.
  • A different participant advises on formatting options for each data series, including setting marker options and line visibility.
  • A participant expresses uncertainty about how to use Marker Options in Excel.
  • One participant confirms they successfully implemented the suggestions and thanks others for their help.
  • Another participant humorously notes they initially used random numbers before applying the method to their actual data.

Areas of Agreement / Disagreement

Participants generally agree on the methods to plot the data, with no significant disagreement noted. The discussion appears to be resolved with successful implementation of the suggested techniques.

dRic2
Gold Member
Messages
887
Reaction score
225
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:

gr.png


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

Attachments

  • gr.png
    gr.png
    13.6 KB · Views: 560
Physics news on Phys.org
In the Excel "Insert" tab, try Scatter Plot, and choose what kind of lines you want to connect your dots with... :smile:
 
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.
 
  • Like
Likes   Reactions: dRic2
How do I use Marker Options ? I'm not very good with excel
 
OK I did it. Thank you very much!
 
  • Like
Likes   Reactions: berkeman
wow that was quick ! I hope it looks as you wanted.
 
Ahahahah I tried with some random numbers. Now I'm going to do the real stuff ;)
 

Similar threads

Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
3K
MATLAB Getting Error When Plotting Graph (Using Python w/ matplotlib.pyplot)
  • · Replies 5 ·
Replies
5
Views
3K
Graphing Data in Excel: Error Bar Confusion
  • · Replies 1 ·
Replies
1
Views
2K
MATLAB To what extent is the fit to experimental data good?
  • · Replies 12 ·
Replies
12
Views
4K
MATLAB Troubleshooting Best Fit Line and Distance Calculation in MATLAB
  • · Replies 14 ·
Replies
14
Views
4K
MHB What is the Graph of $f(x)=3\cos(\pi x-2)+5$ with Amplitude and Period?
  • · Replies 6 ·
Replies
6
Views
2K
MATLAB Mastering Matlab: Graphing Functions Made Easy
  • · Replies 1 ·
Replies
1
Views
4K
Mathematica Mathematica - How to Graph Direction Fields of ODEs?
  • · Replies 9 ·
Replies
9
Views
3K
MATLAB Using repmat to plot a periodic function
  • · Replies 3 ·
Replies
3
Views
2K
Mathematica Adapting Unwrapping Techniques for Plotting Phase Values
  • · Replies 1 ·
Replies
1
Views
2K