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
Click Here for Free Excel Templates
Enrol in Simple Sheet's Excel University - FREE Taster Course
All purchases help to support this blog - thanks!
Click Here to Buy Mediocre Wall Art (& Other Tat) by Chester Tugwell
