​

• ​Select the chart you want to add

• Select the range with the Actual Results

• Can be created from normal cells, tables and Pivot Tables

• Data Range can both horizontal or vertical

• Template available

• Available with both Higher the Better (Up) and Lower the Better (Down) options

• Can have negative totals

• Every line can be total value. To do that, simply write "Yes" in the Total column. The value cell for the respective row must be empty (see below)

• The first value can be changed, so that it is not a Total. To do that, write "First" in the column Total. (see below)

• Works best with Excel 2013 or newer. Older versions will not be able to show the data labels and may prompt and error.