My pivot table is sort by the values in descending order. For the physical sports of the same values as boxed in red, how to have a secondary sorting of the sports name? Thank you.
Sort the pivot table in ascending order by sport first, then by value in ascending order. A bar chart will then display in descending value order and keep the sports in alphabetic order.
See attached.
@riny Currently I sort the values by Top 10 descending. If I sort the sports name first, I won't be able to have a secondary sorting of the values by Top 10 descending.
Ah, I see. That combination makes it difficult indeed. The only solution I can offer is by creating the bar chart from a structured data table that is custom sorted. First by value in descending order, then by sport in ascending order. Then filter the table to for the top values. In the attached file the example is for a top-5 chart.
