Help identify trends
When presenting data in the form of charts or graphs, it can be helpful to include average lines, which explicitly detail the key trends emerging from the information. This may help demonstrate the key points to other users in a straightforward manner - for instance, an executive from a different department during a board meeting. Excel allows trend lines to be extended beyond the graph, to offer predictions of future activity - and such forecasts can help businesses develop their future strategy.