C
Cool Sport
Hi there,
I have been trying to create a custom legend section of a bar chart. I
have a list of backcolor, forecolor and pattern for each
seriescollection.
The legend will be created as shapes automatically and formatted as
correspondent series of the chart.
Everything works fine except the backcolor and forecolor. They all use
the same schemecolor values but appear differently.
For instance:
seriescollection(1).fill.backcolor.schemecolor = 10
shapes(1).fill.backcolor.schemecolor = 10
The rest is just similar, but they display different color.
I double checked by using
debug.print seriescollection(1).fill.backcolor.schemecolor
debug.print shapes(1).fill.backcolor.schemecolor
Results are same as assignments
Color palette has been reset too.
Anyone got any clue?
Very appreciate
I have been trying to create a custom legend section of a bar chart. I
have a list of backcolor, forecolor and pattern for each
seriescollection.
The legend will be created as shapes automatically and formatted as
correspondent series of the chart.
Everything works fine except the backcolor and forecolor. They all use
the same schemecolor values but appear differently.
For instance:
seriescollection(1).fill.backcolor.schemecolor = 10
shapes(1).fill.backcolor.schemecolor = 10
The rest is just similar, but they display different color.
I double checked by using
debug.print seriescollection(1).fill.backcolor.schemecolor
debug.print shapes(1).fill.backcolor.schemecolor
Results are same as assignments
Color palette has been reset too.
Anyone got any clue?
Very appreciate
