EAF #103: Use formula or VBA to colour each column in a chart

This video shows two methods of conditionally colouring each column in a chart. The first method uses an IF function to split the series into groups and the second uses VBA to individually colour each column using RGB codes. If you are interested in more Excel tutorials check out my three series on Vimeo for S&Cs and Sport Scientists https://vimeo.com/ondemand/athletemonitoring https://vimeo.com/ondemand/strengthtemplate https://vimeo.com/ondemand/excelforstrengthcoaches Discount codes below (different codes for US v rest of world) Intro to Excel for S&Cs Tricks or TricksUS = 50% Excel Tricks for Sports: Create an Athlete Monitoring System Track or TrackUSA = 50% Excel Tricks for Sports - Strength Training Manager ET4S or ET4SUSA = 50% If you are a performance analyst then consider this video series and other excellent resources from the videoanalyst http://thevideoanalyst.com/courses/excel-for-analysts/