In a previous video ([ Ссылка ]) I showed how to replace the legend in a column chart with labels added using a scatter chart. Someone asked if this could also be done for a bar chart. This video shows you how. It is a slightly different approach because the scatter plot has to be placed on top of the bar chart. Like before, this method doesn’t replace any data labels for the bar values and gives you the flexibility of which set of bars the names appear in.
These videos are inspired by the customized FinancialViz courses I deliver to business professionals that help them visually communicate financial results and analysis. Learn more at [ Ссылка ].
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:42 The approach
2:47 Create the bar chart
4:05 Add scatter plot data series
7:01 Set axis scales
8:49 Add data labels
11:26 Adjust label positions
13:16 Wrapup
