ajjava
03-25-2019, 05:58 PM
I just found two ways to accomplish the same task (change the color of a data series in a chart), and I'm glad.
HOWEVER
How does one know what the correct objects/properties are to use, when intellisense doesn't engage and when MS Help doesn't offer any suggestions? Isn't there some sort of reference that lists objects and then all the potential properties that can be set/changed?
For instance, to accomplish my above goal with the data series, both of these worked:
.SeriesCollection(1).Format.Fill.Forecolor.RGB = RGB(155,155,155)
.SeriesCollection(1).Interior.Color = RGB(155,155,155)
Do you know how many combinations of various properties I had tried, before finding those two ways? Surely, there's an easier way. Yes? Please?
HOWEVER
How does one know what the correct objects/properties are to use, when intellisense doesn't engage and when MS Help doesn't offer any suggestions? Isn't there some sort of reference that lists objects and then all the potential properties that can be set/changed?
For instance, to accomplish my above goal with the data series, both of these worked:
.SeriesCollection(1).Format.Fill.Forecolor.RGB = RGB(155,155,155)
.SeriesCollection(1).Interior.Color = RGB(155,155,155)
Do you know how many combinations of various properties I had tried, before finding those two ways? Surely, there's an easier way. Yes? Please?