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

A line chart shows changes over time in ... how grouped data points are distributed within a range. It uses a series of bars ...

Highlight the data range ... chart. Right-click the Target data series and choose Format Data Series from the context menu. A Format Data Series pane will appear on the right. Click the Fill and ...

While Excel's charts are ... the best way to create a mini-line chart showing a linear trend. The Create Sparklines dialog box will already contain the Data Range, as you selected this in the ...