what if the second range is sorted automatically by an worksheet-change
event? would that change the chart, too?

Yes it would.

The limitations of Rank can be overcome.

--
Regards,
Tom Ogilvy

"arno" wrote in message
...
Tom Ogilvy wrote:
To the best of my knowledge, a graph can reverse the order, but it
can't sort. So the solution would be to put formulas in another
location that produce a sorted list and build your graph from that.
This list could be on a hidden sheet as an example.

what if the second range is sorted automatically by an worksheet-change
event? would that change the chart, too?

I thought about using formulas as you mentioned (eg. with rank),
however, what if two have the same rank?

arno