Skip to main content
Solved

Sorting Chart Series

  • September 17, 2019
  • 0 replies
  • 158 views

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

Best answer by MarkShnierYou

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------