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 ...

How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet ...

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.

Scatter graphs are a good way of displaying two sets of data close data Values, typically letters or numbers. to see if there is a correlation, or connection. Example ...