I want to move the position of cyclic group icon in bar chart , is that possible?

[#1]

Hi,

Please help me with satisfying answer that work, is there any possibilities to move the cyclic group icon in a bar chart.

Other than pressing CTRL and Shift , click and drag...??!!!!

[Anil_Babu_Samineni]

There is no such function, But, I wonder How Ctrl + Shift will work for you in Groups. I don't think whether it will work for you or not. Can you re-check that function

[#3]

It is not working for me really, but i used to see this answers from different developers...even i also wonder, how it is working for them?!! i just need a solution , other than this CTRL and Shift option.(not working option !).

[Peter_Cammaert]

No you cannot move the cyclic dimension group icon, unfortunately. However, you can hide the icon by removing the dimension label.

"But how does this help me?" I hear you asking. Remember that every instance of a cyclic dimension group is linked. If you make a field selection in one instance in one table, another instance in another chart on another sheet will follow suit and show the same field. We can use this effect to good order by creating a copy of your current chart with the dimension label enabled, all chrome & expressions removed and the chart resized so that it only shows the Cyclic Dimension group icon. Put the remaining icon on the top layer and position this fragment wherever you want on your original chart. Great hack

Best,

Peter

[Peter_Cammaert]

It seems I never posted more than half explanations or full text descriptions, so here you go.

Visual explanation:

For a working example, see the attachment (from which the screenshot is taken).

Note that there are other approaches using list boxes or object captions available in the community.

Best,

Peter

[lauranvh]

This is a great workaround. Thanks!