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
Смотрите видео Excel Chart Tip: Add a goal or target line to a bar chart онлайн без регистрации, длительностью 20 минут 33 секунд в хорошем hd качестве. Это видео добавил пользователь ThinkOutsideTheSlide.com 23 Август 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3 тысяч раз и оно понравилось 22 людям.