Okay, so I have to make a scatter graph for a data table and I have everything done, but I have one problem the points are following the wrong axis. so fo my x axis is time , and my y is mass I need the points to line up with the mass not the time how do I change this I'm using excell 2007
If you are using Excel 2007, then the following process is applicable. In other i'm not sure
To make a scattered diagram, you may be using one dependent variable and one independent variable.
1. First go to insert tab
2. choose scatter graph
3. select the data source
a) Select the independent data for Horizontal Axis and dependent data for vertical axis
4. It will generate a graph, but it has a line attached
5. Select the line, go to shape outline drop-down, choose no-outline
6. also remove the legend
7. You will obtain a scattered plot
Thanks to all of you for the help I got it down now it took me 5 mins to make the last one I needed to.