One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

Visualizing TREND and FORECAST Results Select the data range including your original data and the TREND or FORECAST results. Go to the Insert tab and choose a chart type, such as Line or Scatter.

Open the Excel workbook that contains the chart whose trend-line equation you want to access. Press "Alt-F11" to open Excel's Visual Basic Editor.

If you want to make your charts easy to interpret, insert a trendline or moving average line in Excel worksheet. See the list of steps to get it done in no time!

Excel offers a wide variety of charts and graphs, each designed to help you uniquely visualize data. But choosing the right chart isnt always straightforward.

You can quickly highlight the trends by using sparklines, which are mini graphs of selected data. In the Excel screenshot below, for example, the sparklines in Column F are mini line graphs showing ...

Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.