**Grab the Free VBA Quick Reference Guide
www.chrisjterr...
**Get the file download here
chrisjterrell....
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
Негізгі бет VBA Chart Project - Change Bar and Column Color
Пікірлер: 2