A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.
An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I show below.
 Helpful Resource:
