CharlesThomas
New Member
- Joined
- Apr 30, 2013
- Messages
- 1
For my charts, I am using the Technic theme, Style 27. To best represent my data I need to reverse the order in which formatting is applied to bars. It currently goes from darker to lighter, and I want lighter to darker, using the Technic Style 27 to match 50 pages of other charts I’ve already done.
*Basically, I have a bar chart with six series, and I’d like to swap the formatting between bars 1 and 6, 2 and 5, & 3 and 4.*
What I’ve tried thus far:
For Technic Style 27, the GradientColorType is msoGradientMultiColor and the GradientStyle is msoGradientMixed. I’ve been trying to copy the fill properties from one bar to another without success – the only methods available seem to be OneColorGradient and TwoColorGradient, and neither seem to accept msoGradientMixed as a gradient style.
I have been trying to set the fill properties using:
Microsoft seems to suggest that you can use msoGradientMixed this way, but it returns an out of range error.
OneColorGradient Method
Would appreciate any help!
*Basically, I have a bar chart with six series, and I’d like to swap the formatting between bars 1 and 6, 2 and 5, & 3 and 4.*
What I’ve tried thus far:
For Technic Style 27, the GradientColorType is msoGradientMultiColor and the GradientStyle is msoGradientMixed. I’ve been trying to copy the fill properties from one bar to another without success – the only methods available seem to be OneColorGradient and TwoColorGradient, and neither seem to accept msoGradientMixed as a gradient style.
I have been trying to set the fill properties using:
ActiveChart.SeriesCollection(1).Fill
and have tried manually setting values for OneColorGradient (or TwoColorGradient) as well as copying the style, variant, and degree parameters from a bar with the formatting I’d like to copy.
Microsoft seems to suggest that you can use msoGradientMixed this way, but it returns an out of range error.
OneColorGradient Method
Would appreciate any help!
