In which situation would it be best to use a line chart
Line charts are useful for showing trends between data points. Use line charts to show the frequency of the values of a field or the output of an aggregation function. The data points are connected by lines to help display patterns or trends. Hope this answers the question.