How to Make a 2 Variable Graph in Excel
Make a two variable graph in Microsoft Excel with its built-in spreadsheet and chart tools. Two variable graphs demonstrate the relationship between two sets of numerical data. They are often displayed with a scatter plot which creates one data point from two sources of information. Create the scatter plot in Excel and then customize it with the Design, Layout and Format tabs of the Ribbon. You can insert additional components to your chart such as labels, titles and trendlines.
Open your Excel spreadsheet with the quantitative variable information. If you don't have an existing spreadsheet, create a new one from the File tab of the Ribbon. Input your numerical variables into columns A and B.
Label your columns by typing titles into the first row of your columns A and B. If necessary, insert a new row by right-clicking the row header and selecting "Insert." Organize your data so that the data points in column A correspond with the data points in column B.
Highlight your entire data set, click the "Insert" tab of the Ribbon, click the "Scatter" drop-down box and select the desired scatter plot style. Click and hold the bottom right-hand corner of your chart and drag it to change the chart size. Select the color scheme and style from the Design tab of the Ribbon.
Tips & Warnings
- Analyze the association between your two variables by adding a trendline. Click the "Layout" tab of the Ribbon, select "Trendline," choose "More Trendline Options" and select the trendline that fits your data points.
- Customize your chart from the Format tab of the Ribbon. Change the styles, colors, fill, effects and font appearance.