If you are dealing with data involving comparative analysis of values spread across 2 different columns, try using the Line Chart or the Scatter Plot Graph. The procedure to create a line chart ...

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

Launch the Excel 2010 spreadsheet that holds the scatter plot you want to adjust. Click anywhere on the chart, then click the "Layout" tab that appears at the top of the Excel window.

Plot each data point carefully on the graph. ... Construct a scatter graph that represents these results. ... Line graphs. count. 2 of 6. Pictograms. count. 3 of 6.