You can use a line chart in Excel to display trends over time. In Excel, line charts are appropriate if you have text labels, dates, or a few numeric labels on the horizontal axis (x-axis). Here are the steps to create a line graph in Excel. (If you are using numeric labels, empty cell A1 before you create the line chart): After inputting in your values, select the range (whatever range encompassing those values). For example, A1:D7. On the Insert tab, in the Charts group, click the Line symbol ("Insert line chart") Click "Line with Markers"