Data Graphics disappear behind some shapes

[Visisthebest]

When I set data graphics on some shapes, the data graphics disappear behind the shape.

The displaylevel on the shape and its subshapes is set to 0, just like the data graphics.

Is there a way to specify data graphics when they are added to the page should have a higher display level, or should always appear on top?

Weirdly, I cannot fix this by moving the group shape back, only the specific subshapes.

[Visisthebest]

I tried to set the DisplayLevel in the subshapes to a minus level, so I would expect this to fix the issues when I add data graphics to the group shape.

It does not, the data graphics still disappear behind some subshapes. If I move these subshape back (Send to back), then the data graphics will show.

I wonder how I can make sure the data graphics appear on top of all subshapes in the group shape, to force this in a group shape with subshapes which seem to behave oddly this way.

[Visisthebest]

Ok, so to prep these group shape I try to run this VBA on the group shape, before data graphics are applied.

The code does a SendToBack on all subshapes a 100 times, doing this hoping it resets the Z order way backwards of all the subshapes.

Code Select Expand


Sub SendSubShapesToBackXTimes()

Dim S As Shape

Set S = ActiveWindow.Selection(1)

Dim SS As Shape

Dim Looper As Integer

For Looper = 1 To 100

For Each SS In S.Shapes

SS.SendToBack

Next

Next

Dim SSCount As Integer

SSCount = S.Shapes.Count

MsgBox (CStr(SSCount))

End Sub


but no luck, still I have to SendToBack several subshapes AFTER applying data graphics.

How can I prepare the Z order of the subshapes in a group shape so they always appear behind Data Graphics?

[wapperdude]

I wonder if this a VSDX issue and problem goes away f saved as VSD?

[Visisthebest]

Yes I read the other post on this I will try this and let you know.

Editing the VSDX XML I will try as well, have a hunch that is a solution also.

[Visisthebest]

Tried to save to VSD but makes no difference.

What works though is the horrible option:

after an ungroup, then group again...

the behavior is fine and data graphics appear on top of all subshapes.

Hope to find a better way to deal with this.