Excel Chart Tip: Add a goal or target line to a bar chart
When you are showing ranked data in a bar chart you may want to add a goal or target line to easily identify those with performance above the goal and those below the goal. Instead of drawing the line on top of the chart, build the target or goal line as part of the chart so it updates automatically when the data or the goal updates.
These videos are inspired by the work I do with business professionals to visually communicate financial results and analysis.
In the video I am using Excel 365 on Windows 10, and most modern versions of Excel and PowerPoint will look very similar. If you like the video, please subscribe to the channel and add a comment below.
If you want to learn what you should do to create presentation-ready Excel charts that are easy to update and re-use, sign up for my free mini-course at
If you want quickly learn expert-level Excel techniques to create presentation-ready charts that are easy to update and re-use without programming, add-ins, or web tools, check out my Excel Chart Skills 501 course at
You can access an entire playlist of Excel Chart Tips videos at www.ExcelChartTips.com.
0:00 Introduction
0:40 Create the bar chart data table
3:01 Create the goal line data table
4:52 Create the bar chart
12:19 Add the goal line to the bar chart
19:00 Extending this idea to other visuals
Watch video Excel Chart Tip: Add a goal or target line to a bar chart online without registration, duration 20 minute 33 second in high hd quality. This video was added by user ThinkOutsideTheSlide.com 23 August 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3 thousand once and liked it 22 people.