How to sort row axis labels in order on Chart from Table Macro?

[David Jiang]

I created a chart using the Chart from Table macro. The chart displays inputted data from various fields that I specified. My issue however is that the chart is not displaying the row axis in order as shown in the chart screenshot. I want to sort it so that the shifts are displayed in order (First > Second > Third > Fourth > Fifth). The second screenshot shows the macro sequence that I have set up to generate the chart. I've tried using the sorting options in the nested macros but none of them seem to work. Is there some other way for me to manually specify the order that I want the chart to display the row axis values?

[Stiltsoft support]

Hi @David Jiang ,

As you've mentioned the Chart from Table macro, we suppose that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app.

As we understand, you use a Stacked Column chart type where you choose the 'Shift' column as a Labels column.

The values from this column are taken one by one starting from the first row. If you sort this column in the Table Filter macro, then the order will change (as you have strings and not numbers, the sorting will be alphabetical).

So, to get the sequence as First > Second > Third > Fourth > Fifth, you should have the same sequence in your source table.

If the order is a random one, you may use the Table Transformer and assign a correspondent number to each text value: First = 1, Second =2, Third = 3, and so on. Then you can sort by this new column and get the required sequence.

If you have further questions regarding the app, please contact our support directly.