How To Make A Line Graph In Excel With Multiple Variables

For ease of use set your x axis data time in the left column and your recorded observations in the right column.

How to make a line graph in excel with multiple variables. For example your first series of data might be 10 data points on impressions and your second series might be 10 data points on conversions. Right click a column in the chart and select format data seriesin the context menu. A line graph requires two axes in order to function. Click the insert tab line chart line.

Other versions of excel. Making graphs with multiple lines is just as easy as creating single line graphs. Highlight both columns of data and click charts line and make your selection. There are spaces for series name and y values.

To draw a multiple line graph perform the same steps as for creating a single line graph. Select the data range and insert a chart first by clicking insertand selecting a chart you need in thechartgroup. You would then need to go to the insert tab at the top of your screen and select the type of line graph that you like best. Time intervals in the left column and observations numeric values in the right columns.

However your table must contain at least 3 columns of data. To create a combo chart select the data you want displayed then click the dialog launcher in the corner of the charts group on the insert tab to open the insert chart dialog box. Start by creating a line chart from the first block of data. For example tracking your budget over the year would have the date in the left column and an expense in the right.

We chose line for this example since we are only working with one data set. Analyze the association between your two variables by adding a trendline. Organize your data so that each category has all the corresponding values in the same row or column. Each data series will be plotted individually.

Click the layout tab of the ribbon select trendline choose more trendline options and select the trendline that fits your data points. Then highlight your data and click the 2d line button. Customize your chart from the format tab of the ribbon. Enter your data into two columns.

Right click the chart and choose select data from the pop up menu or click select data on the ribbon. From here you can use all the same editing techniques to customize your multi line chart. Select the chart type you want for each data series from the dropdown options. Excel creates the line graph and displays it in your worksheet.