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.

--
Regards,
Tom Ogilvy

"Dharsh" wrote in message
...
Hi there! I neet to plot a simple graph with the data below

Candidate Score
A 4
B 3
C 7
D 1

The relevent numbers (are actually scores) keep getting updated for each
candidate. I want my graph to plot it in the order of highest score to
lowest (whilst keeping my spreadsheet in the same order A,B,C,D . . .)
every time I update the score (automatically) without me having to change
it
everytime I do it.
I have 32 entries. Can I use a macro to do this
Can anyone pls help me plssssssssssss

Thanks so much in anticipation

Dharshanie