Skip to content
Home ยป Add Horizontal Target Line to Excel Chart | Actual vs Target Chart With One or Multiple Target Lines

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

     

    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.

    Click here to download the featured file.

    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