Excel offers a wide variety of charts and ... In such cases, a column chart is the better choice. A line chart shows changes over time in a data set by connecting two data points with a line.

Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.