Below is a small sample of the data used to plot this chart. This data can be downloaded from Yahoo Finance.

Steps to create

  1. Create a Line Chart with Date and Close data only.
  2. Remove extra data series, leaving only Date and Close.
  3. Make sure x-axis is formatted as a Date axis.
  4. Set Major units to 5 years, minor units to 1 year.
  5. Set bounds to 1/1/1990 and 1/1/2020.
  6. Apply number format to the axis (“yyyy”) in this case.
  7. Adjust upper bounds for y-axis as desired.
  8. Add a title and apply text formatting as needed

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Line Chart example  Line chart with many data points - 37Line Chart example  Line chart with many data points - 54