VBA Chart Project - Change Bar and Column Color

Опубликовано: 04 Октябрь 2024
на канале: EverydayVBA
3,089
17

**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