Have you considered using the LARGE function?

"Evan" wrote:

Hello,
I have a pretty simple bar graph chart that is pulling data from about 10
different cells. I was wondering if there is anyway to format the chart so
it displays the highest value 1st, followed by the 2nd highest, etc. without
actually sorting the original set of data. I'm looking for a pareto chart of
sorts. Thanks for the help!