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 a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.