Line charts are for displaying time series data (or, in everyday language, they’re for showing patterns over time).
In this video, I demonstrate how to insert a brand new line chart that displays the number of professors who are employed between Fall 2001 and Fall 2009.
Sometimes Excel gets confused by line charts. For example, Excel often takes the information from our data table’s rows and puts that information in the vertical columns of our line charts. There are two possible solutions. First, I teach you to use Paste Special to transpose your data table. Second, I demonstrate how to quickly fix Excel’s mistake by using the Switch Row/Column button, which lives in the Chart Tools > Design tab along the top of your spreadsheet.