I thought I had this figured out, but for some reason it's still not displaying correctly.
I need to display text values as the x-axis (poor, fair, good, excellent) in that order. The values are linked to a numeric "scale" so that Poor = 1 (in separate fields but the same table); both fields are in the query that the chart is based on, and ascending order set to the numeric field, but the x-axis still displays them in random order.
More info: the numeric field is in the query called by the chart wizard, not the actual SQL statement that makes up the chart. When I add the numeric sorting field to the SQL statement, it solves this problem, but also adds another "series" (bar) to the chart...
any suggestions?
I need to display text values as the x-axis (poor, fair, good, excellent) in that order. The values are linked to a numeric "scale" so that Poor = 1 (in separate fields but the same table); both fields are in the query that the chart is based on, and ascending order set to the numeric field, but the x-axis still displays them in random order.
More info: the numeric field is in the query called by the chart wizard, not the actual SQL statement that makes up the chart. When I add the numeric sorting field to the SQL statement, it solves this problem, but also adds another "series" (bar) to the chart...
any suggestions?
