Power View - Reorder items on X axis of chart

aexley

New Member
Joined
Sep 18, 2014
Messages
3
Hi.

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,
Andrew.
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

scottsen

Well-known Member
Joined
Mar 16, 2014
Messages
1,263
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?
 

aexley

New Member
Joined
Sep 18, 2014
Messages
3
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

Threads
1,106,041
Messages
5,508,953
Members
408,702
Latest member
daz457

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...
Top