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.

Nonetheless, I think that it's a fantastic option if you don't want to work from Excel; add other people's email addresses and let them collaborate/update in real-time. Smartsheet's Gantt chart ...

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.