**Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-v...
**Get the file download here
https://chrisjterrell.com/blog/223074...
In this project, we will build out a macro that will change the color of a Bar or a Column based on a Cell Color that matches the name in the Axis. In this video, we show how the code will work and do some drilling in the Locals window to explore the ChartObject, FullSeriesCollection, Xvalue, and Points.
In the next videos, we will loop through all the sheets, all the charts, and all the FullSeriesCollections.
This ONE WILL BE FUN