PASTE SPECIAL with formulas
Add, subtract, multiply or divide a set of values by another value, using ‘Paste Special’.
Excel Quick Help Videos
Add a REFERENCE LINE to a HORIZONTAL BAR chart in Excel
To add a reference line such as an average or benchmark to a horizontal bar chart.
Add a REFERENCE LINE to a VERTICAL BAR chart in Excel
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.