Check the smoothed line box.
How to make a graph with two sets of data. To get started with the scatter plot in excel, follow the steps below: Combining data sets into a graph the first step in combining two graphs is selecting the data sets that will go into the graph. Open your excel desktop application.
=rsq([data set 1],[data set 2]). Select the entire data range and insert a simple column chart. Click the search box and type “dual axis line chart”.
Once the chart pops up, click on its icon to get. Set the width to 1.25 pt to make a thin line. Insert the data in the cells.
Select the sheet holding your data and click the. Graphing two data sets on the same graph with excel youtube from www.youtube.com. Once you have setup your data you need to highlight all your data and then click.
You can find the stacked bar chart in the list of charts and click on it once it appears in the list. The first step is to make sure your data is formatted correctly for charting. Paste the table into your excel spreadsheet.
This process takes several steps to complete. 2 select fill & line. Select the series you want to edit, then click edit to open the edit series dialog box.