Sort legend

[Anonymous]

Hi community,

Is possible sort legend by Y value and the last should be 'Other' tag?

For example

Variable1

A=39%

B=35%

C=20%

D=15%

Other=23%

Match(Variable1,'A','B',...'Other') doesn't help, because A, B, C will be different each time.

Thanks,

[Clever_Anjos]

One option is put a straight table (not total row, no caption) with Dimension Limit properly set right above your graph.

PFA

[Anonymous]

Most my tables have 2 dimensions

[Clever_Anjos]

You expect you legend having two dimensios plus a value?

[Anonymous]

Please see my attached file.

When I sort by Y value, my Months are sorted wrong.

I'd like Purpose of visit will be sorted by Y-value and the last Other specify and Months go in right order.

Any suggestion?

[Clever_Anjos]

PFA

[Anonymous]

It resolved sort by Y-value with Months right order

thank you so much.

You don't know how to set up Other specify in the last row in the table?

[Clever_Anjos]

You´re using Pivot Table, that does not support Dimension Limits.

Only straight table can do that

[Anonymous]

Thanks for your helping