Unanswered: Report graph not in abc order/reverse abc/by y-value?
Hi out there,
I've tried looking all over for a solution to this problem and can't find anything... is there anyone who can help me?
I've got a report bar graph showing the number of participants in a survey (y-axis from 0-20), and the timing of lake ice melting (x-axis columns with labels "early", "average" and "late").
The program automatically puts the x-axis labels in alphabetical order. But I need the x-axis ordered in that exact order: early, average, late. Not in alphabetical order. Not in reverse alphabetical. And not according to their corresponding values on the y-axis. This order just makes sense qualitatively in relation to their context in the report (which for clarity's sake is observed climate changes).
So I went about making a separate table with only the two fields "Order Number" (1,2,3) and "Timing" (Early,Average,Late). Then I added the table to my graph query and added the "Order Number" field and sorted by it.
So now my graph query has three fields: Year (first sort ascending), Order Number (second sort ascending), and Timing (Early, Average, Late). The Order Number sort works in the query! Finally I have it sorted in the order of "Early-Average-Late" for each year. Thank you for that!
However, when I make the graph with the Graph Wizard in my Report (Timing on x-axis, Year in the legend represented by different coloured bars, Data on the y-axis left blank so the program gives me automatic counts), it still does not give me the correct order...
How do I get the graph to reflect the same order as the query?