scottcolbury
New Member
- Joined
- Dec 6, 2005
- Messages
- 45
Hi all,
I can change the series collection fill of a bar chart with the code: ActiveChart.SeriesCollection(1).Format.Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent1
However, I cannot figure out the syntax to change the chart series collection border in a similar manner. I tried the code below but it does not work.
ActiveChart.SeriesCollection(1).Format.Border.ObjectThemeColor = msoThemeColorAccent1
Please help.
s_c
I can change the series collection fill of a bar chart with the code: ActiveChart.SeriesCollection(1).Format.Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent1
However, I cannot figure out the syntax to change the chart series collection border in a similar manner. I tried the code below but it does not work.
ActiveChart.SeriesCollection(1).Format.Border.ObjectThemeColor = msoThemeColorAccent1
Please help.
s_c