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

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
www.paypal.com/donate/?hosted_button_id=CGKRY2BAYE…
Thank you! 👍👍
Download the featured file here: www.bluepecantraining.com/wp-content/uploads/2023/…

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.

One way you can display multiple targets ( a different target for each data point ) is to use markers on a scatter graph, and this is the method I use in the video.

Table of Contents
00:00 Introduction
00:12 Create a chart with multiple targets ( a different target for each data point )
02:27 Display a single target with a horizontal line
-------------------