Forum Discussion

NigelHo's avatar
NigelHo
Qrew Trainee
5 years ago
Solved

Sorting Chart Series

Helo


I have preparing a Bar Chart and have a series for Project A, B, C, D & E

With this bar chart, I am summarizing the 3 Sum Values

01 Initial Cost
02 Current Cost
03 Forecast End Cost

So I am expecting a bar chart that have 5 sets of 3 bar values starting from Project A from the left and ends with Project E on the right. 

However, I get a sequence of Project A, C, D, E & B

I have tried various ways to change the sort order but can't seem to find a solution. 

Appreciate some help. 

Thanks

------------------------------
Nigel Ho
------------------------------
  • OK, in the field properties for that multiple choice field, have you set that field to sort alpha or sort "in the order above".

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------

4 Replies

  • I'm trying to understand your problem. Are you saying that the projects are NOT sorting alphabetically.  Is the Project Name field from a multiple choice list? If so, what is the field property set to for that multiple choice field's sort order?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • NigelHo's avatar
      NigelHo
      Qrew Trainee
      Hi Mark, 

      Yes. The projects are not sorting alphabetically. 

      Yes. The project name field is from a multiple choice list.

      ------------------------------
      Nigel Ho
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        OK, in the field properties for that multiple choice field, have you set that field to sort alpha or sort "in the order above".

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------