Originally Posted by
June7
Y-axis data is text therefore alphabetic sort applies.
Sample table shows data is already summarized so why use grouping query?
Is this Modern Charts? In old MSGraph chart I would modify chart RowSource SQL:
SELECT KeywordCount, Format(KeywordCount, "00") & Keyword AS Cat FROM table;
But why is numeric order so important? That's a main reason for graphic representation of data - easier comparison of numeric values regardless of order. And having the alphabetic sort by keyword makes it easier to find a particular item - "How well did oranges do - oh wow they surpassed everyone!"