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 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 presentation-ready Excel charts that are easy to update and re-use, sign up for my free mini-course at https://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 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
Смотрите видео Excel Chart Hack: Put data series labels in the bars of a bar chart instead of the legend онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ThinkOutsideTheSlide.com 17 Январь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,318 раз и оно понравилось 19 людям.