Add reference lines to dynamic charts to set adjustable benchmarks or targets.  

Draw a reference line behind your data with dynamic charts.  You can have one or two lines, and optionally shade the area in between them.

The reference values come from an Excel range. You get a line for each row of data, and the shape of the line is determined from the values in the columns.

Reference lines aren't available for Bar charts.