Add Horizontal Target Line to Excel Chart | Actual vs Target Chart With One or Multiple Target Lines

Microsoft Excel Tips and Tricks

In this video I demonstrate how to add a horizontal target line to an Excel column chart. You can add one or multiple target lines to an Excel chart. If you have one target you will need a line that spans the width of your chart: this can be tricky to achieve. In this video I demonstrate how to create such a line using error bars.

Credit Chester Tugwell