Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
One option is put a straight table (not total row, no caption) with Dimension Limit properly set right above your graph.
PFA
Most my tables have 2 dimensions
You expect you legend having two dimensios plus a value?
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?
PFA
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?
You´re using Pivot Table, that does not support Dimension Limits.
Only straight table can do that
Thanks for your helping