One way to give more meaning to your numbers in Excel ... on the x-axis, but we want the trend data to show as a line. To amend this, click anywhere on the chart, and select "Change Chart Type ...