Question

In which situation would it be best to use a line chart

Answer 1

When you require a line.

Answer 2

Line charts are useful for showing trends (usually over time). As opposed to showing proportions (where you'd use a pie chart) or showing the relative magnitude of things (where a bar or column chart is usually considered slightly better).