In a previous video ( • Use this hack to add the data series ... ) 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 http://www.FinancialViz.com.
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 presentationready Excel charts that are easy to update and reuse, sign up for my free minicourse at https://thinkoutsidetheslide.teachabl....
If you want quickly learn expertlevel Excel techniques to create presentationready charts that are easy to update and reuse without programming, addins, or web tools, check out my Excel Chart Skills 501 course at https://thinkoutsidetheslide.teachabl....
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