How to create a graph:
1. Put in the data into the cell boxes in excel
2. highlight all the cells with the data and go to plot scatter graph.
This will give you a graph that looks like this:
3. Make sure to add a title, and lable the axis with the correct units.
4. If the dots seem to make a straight line, it is possible to draw a "best fit" line through it and show the equation for the graph.
If these four simple steps are followed, it will be really easy to make graphs using excel when there is a set of data that needs to be graphed.
No comments:
Post a Comment