How-to automatically select and chart the highest 10 totals?

try this formula:

=LARGE($A$1:$A$25,1) will return the largest value in your range
=LARGE($A$1:$A$25,2) will return the second largest value in your range and so on up to
=LARGE($A$1:$A$25,10) for the tenth largest value.

NOTE: ties will be repeated as many times as they appear. e.g.
1,2,3,3 will show 3 as largest AND second largest, 2 will be third largest.

Plot the results of the formulas.

Good Luck