Launch Microsoft Excel. Type your data in the Excel spreadsheet ... We are going to add a median line to the chart. Enter the formula Median and the range of values; for example =MEDIAN(B2 ...

In an Excel bar chart, each data point is represented by ... you'll have to calculate the area under the plots with formulas.

Excel offers various chart types, but a line chart is the best choice. You now have a chart of your time series and their values based on the trend line calculated by the TREND function.

However, do you know that you can make a curved line graph in Excel or Google Sheets? If not, you should check out this tutorial to turn the sharp edges into smoothed lines. Sometimes you may need ...