RE:Label posiion?

[Chanty4u]

hi all,

is there anyway to change the postion of the cyclic or dril down?

and how to do custom sort order?

PFA image

Thanks in advance...

[its_anandrjs]

Take the clone copy of this chart to another sheet and check the chart alignments.

[its_anandrjs]

You can use trick here as Jonathan suggest for labels only

1. On the original hide the label means not given label but on the top of the chart use label that you want use it as text object and place on top of the chart where you want that.

2. Make the visible property of this object as top so it is visible first.

This trick works but not good idea.

Regards

Anand

[Chanty4u]

but grouping is nt psble ryt...wen we use text object

[its_anandrjs]

You can use  AGGR  function for that in the text objects.

Regards

Anand

[Chanty4u]

THNX ANAND... I HVE DONE CHNGED SOME CHART SETTINGS  and x axis and y axis values....so it become somewat better  .......