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 ;)

*** Sent via Developersdex http://www.developersdex.com ***

It has been ages and no reply, :(

I have found that

shapes(1).fill.backcolor.schemecolor =
seriescollection(1).fill.backcolor.schemecolor + 7

Supprise, I dont know why MS does that.

*** Sent via Developersdex http://www.developersdex.com ***