pivot chart sorting

  1. V

    Sort pivot chart columns dynamically by quantity

    I have a pivot table that I am using to create a bar chart. The filter for the table is based on city. There are four columns with an integer value in each. The bar chart shows the four values as the value fields in each column. What I would like to do is show the largest value first and...
  2. T

    Pivot chart - prevent custom sort from resetting when data is refreshed

    I have set up a data model with the main source of data being a bunch of CSV files in a particular folder. Data is grouped by month via the pivot field which works fine. The only issue is that I need to order the months July-June and every time the data is refreshed they divert back. When I...
    • ToniGo
    • Thread
    • data pivot chart sorting pivot charts month axis refreshed set
    • Replies: 6
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top