Power View - Reorder items on X axis of chart


New Member
Sep 18, 2014

I'm trying to setup a dashboard for a school showing student result distribution. The marks are provided as "A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-" yet when creating a bar chart with a summary count of these results it orders them as "A, A-, A+, B, B-, B+, C, C-, C+, D, D-, D+" on the x-axis.

Unfortunately this dilutes the visual efficiency of the chart as the viewers expect the normal HIGH to LOW order.

As this is my first encounter with Power View, I'm having an interesting time trying to make this appear the way I need it to. I've tried creating a custom sort list to no avail. Can anyone provide a solution to my issue, if there is one?

Kind regards,
Last edited:

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)


Well-known Member
Mar 16, 2014
Assuming the data is coming out to Power Pivot (I actually have no idea if it can come direclty out of a normal Excel table... you probably can, but, well, I'm a bit focused on Power Pivot)... there is a "Sort By Column" button on the toolbar. If you have number based column with a good sort order... that should work for you?


New Member
Sep 18, 2014
Thanks Scott.

Was just opening directly in Excel as an linked data source I didn't think I'd require the overhead of Power Pivot. But unfortunately the data source I import doesn't have a number column that references the results numerically that I can sort.

I did try doing it through Power Pivot and creating an extra column based on IF statements to convert the marks in to a numerical reference (A+=1, A=2, A-=3 etc) yet when I tried to sort the marks column by the new numerical column I ended up with a circular reference error.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...