Line charts are best for seeing trends over a continuous timeframe e.g. revenue by month. They're especially useful for comparing multiple categories of data e.g. revenue of different products by month. Use contrasting colours so that users can easily differentiate series. Display a legend to make it clear what each series means
Best Practices article:
Line Charts
Questions on this topic? See 3.07-02 Line Charts in our Planual forum.