Hello sir,
I've made a query that has part numbers and the count of their respective duplicates so I know how many times each part number occurs.  I have the top 3 displayed in this query and sorted in descending order by count.  I would like to display this in a chart but when I create the chart, it's not in descending order by the number of duplicates, it's by the part number.  I cannot seem to figure out how to correct this.  I would think that it would display the data exactly as it appears in the query but that is not the case.  Can you please help me?

---

Reply from Alex Hedley:

Expert 31 covers Charts.

Are you choosing the Query as your Chart source or the original Table?