Hi All,
I have a chart based on the below pivot table, which I would like it to be sorted from A to Z.
Basically, since the horizontal Axis field is a textual, the sorting getting problematic if I have for instance "Sprint 9", "Sprint 10" & "Sprint 11". In that case the order will be 10,11, 9.
So I added another axis field (in bold) which isolates the number from the string if it contains "Sprint" and in other cases puts 0 (since I want it to appear first).
Now the chart axis shows both categories and I wonder if there is any way to eliminate from the axis display the first one and to leave only that which represents the strings (without losing the capability to order by the other category).
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD]Done[/TD]
[TD]Undone[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]PSI 2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Sprint 8[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sprint 9[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sprint 10[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Sprint 11[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]26[/TD]
[TD]22[/TD]
[TD]48[/TD]
[/TR]
</tbody>[/TABLE]
I have a chart based on the below pivot table, which I would like it to be sorted from A to Z.
Basically, since the horizontal Axis field is a textual, the sorting getting problematic if I have for instance "Sprint 9", "Sprint 10" & "Sprint 11". In that case the order will be 10,11, 9.
So I added another axis field (in bold) which isolates the number from the string if it contains "Sprint" and in other cases puts 0 (since I want it to appear first).
Now the chart axis shows both categories and I wonder if there is any way to eliminate from the axis display the first one and to leave only that which represents the strings (without losing the capability to order by the other category).
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD]Done[/TD]
[TD]Undone[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]PSI 2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Sprint 8[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sprint 9[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sprint 10[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Sprint 11[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]26[/TD]
[TD]22[/TD]
[TD]48[/TD]
[/TR]
</tbody>[/TABLE]