Colors in a sunburst graph

[Eastw00d]

Hi all,
Below I have a "standard" sunburst chart, where I want to do 2 things, 1 to create a ring or segment of the same color and/or 2, to create a color of an individual item, based on the cell content. I have got so far information that I know that the graph is handling points, but in this particular case the number of individual points does not go beyond 16 where Points.Count = 24. That puzzles me.
In this case I want to have "Okt" in green and "-0,8" in red
I probably am making a thinking error, but I failed to see where.

Please Login or Register  to view this content.

Please can you help me out?
Cheers
Erwin

[Bo_Ry]

I'm not familiar with charts properties.
Just give it a try.

Please Login or Register  to view this content.

[Eastw00d]

Thank You Bo_Ry,
This is something that I can work with.

Have a blessed day!
Cheers
Erwin

[Eastw00d]

Although the solution of Bo_Ry is satisfactory, it does not give an answer to my question about the datalabels
pnts = Points.Count = 24, and t is stuck at 16 when it comes to address labels.
When I assign colors only, regardless of labels it goes very well, see below, where in each of the Cells(1, t) is a certain Interior.Color.

Please Login or Register  to view this content.

But my goal is actually to "match" the datatable with the content of the DataLabels. I would expect that there are to be found 24 DataLabels.texts or .Captions and I cannot figure out why this gives an error at t = 16 in a line like:

Please Login or Register  to view this content.

additional information: somehow at t=16 (Jun) and t = 23 (Nov), the HasDataLabel value = False. How is that possible? What is the alternative?

Please Login or Register  to view this content.

Cheers
Erwin

[Andy Pope]

In a sunburst there is only 1 series. The points depend on the relationships within the data. Your debug.print shows you that.
There are 24 individual sectors within the whole chart.

[Eastw00d]

Yes, I agree, but somehow I cannot "catch" Jun and Nov in the action debug.print, or when assigned to, in an array.
This as purpose to have the data as input for a coloring-action.
As like I want to say:

Please Login or Register  to view this content.

somehow at t=23 the graph does not recognize "Nov" as a DataLabel and that is what puzzles me. At this point, HasDataLabel is False. What is Nov than, if not a DataLabel?

Cheers
Erwin

[Andy Pope]

Because you have this line in the code

Please Login or Register  to view this content.

Increase the size of the chartobject and the missing data labels will appear.

The difficult part is point 1 covers more that one point. it covers all the points related to it. The same is true for all but the outer layer of points.

[Eastw00d]

Aha, thank you Andy, this solves the mystery.

Cheers
Erwin