Excel Chart Hack: Put data series labels in the bars of a bar chart instead of the legend

In a previous video ( • Use this hack to add t... ) 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 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 presentation-ready Excel charts that are easy to update and re-use, sign up for my free mini-course at thinkoutsidetheslide.teachabl....
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 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

[@adnanozkara3576]

Thank you , very insightful

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@bradleyann]

Thank you for the clear explanation of how to put a scatter plot on a bar chart. It’s very helpful to understand why it works like it does. Can’t wait to try it out!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful. I hope it works for you.

[@xvnbm]

This should be a basic option in excel. Excel is such an awful program to use.