Macro to change the cyclic group order

[#1]

Is it possible to change the order of a cyclic group by a macro (in a table). I would like to have a button to change the order of 2 dimensions in a cyclic group with 4 dimensions.

sample Cyclic group:

DIMENSION1,DIMENSION2,DIMENSION3,DIMENSION4

After pressing the button i would like to have (so 3 and 4 are changing):

DIMENSION1,DIMENSION2,DIMENSION4,DIMENSION3

If i press the button again i would have to revert to situation 1.

[#2]

Hi,

I just wanted to add, that declaring an array like you suggested brings a type mismatch error in the macro code.

If you use

dim x

x = gp.Labels

instead instead of

dim x(3)

it will work.

Regards.

[#3]

Arthur i was again looking at this very old post from me!

The problem is that my group is a drill group and not a cyclic group

i changed it in the past to use macro but by macro it is getting really slow!

[richnorris]

You could just sidestep the issue entirely with a quick and dirty solution;

Have two identical charts overlayed on top of one another, with a conditional show based on a variable. In one chart you have the cyclic group 1,2,3,4 and in the other chart you have a different cyclic group, which is the same data but in order 1,2,4,3 and then a button which changes the variable the conditional show is checking, so it appears that when you click it, the group order changes.

[#5]

i allready thought of this option, but my document has +/- 15 objects with the same drill group in different sheets.

But it is for sure a possible solution, which works!

thnx