Microsoft Excel Tips and TricksIn 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