Forum

Notifications
Clear all

Sorted Pivot Table, but Pivot Chart is not sorted

2 Posts
2 Users
0 Reactions
585 Views
(@martha-nietoasu-edu)
Posts: 1
New Member
Topic starter
 

i have sorted my pvtable by "Total" Colum in descending order, but my pvchart display in ascending order.  How can i sort so both my Pvtable and PvChart reflects the same sorted order?

 
Posted : 26/02/2022 8:03 pm
(@mynda)
Posts: 4761
Member Admin
 

This happens with bar charts. You can either sort the PivotTable in ascending order or format the chart axis and under Axis Options, check the box 'categories in reverse order'.

 
Posted : 26/02/2022 9:04 pm
Share: