Use this hack to add the data series names in the columns of a graph instead of a legend in Excel
When you are using a clustered column graph in Excel that has two or more data series, how do you tell the viewer which set of columns is which data series? The default method is to use colors and the legend. This video shows you a way to add the data series names into one set of the columns. This is much easier for a viewer to interpret. This method doesn’t replace any data labels for the column values and gives you the flexibility of which set of columns 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
1:02 Data setup for the chart
4:22 Create the column chart
5:04 Add the scatter plot data series
8:11 Positioning the names
8:46 Formatting the data series names
12:31 Adjusting column spacing
13:35 Applying the idea to two columns
14:47 Applying the technique to create a two-level category label
16:15 Wrapup and Next Steps
Смотрите видео Use this hack to add the data series names in the columns of a graph instead of a legend in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ThinkOutsideTheSlide.com 15 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 12,428 раз и оно понравилось 37 людям.