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.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Learn how to build amazing Excel graphs the not only look professional but also feature your company's brand and aesthetics ...

A bar chart is useful when you want to do a quick side-by-side comparison of categorical data (e.g., countries, colors, types of software, modes of transport, marital statuses).

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.