Sort order for chart only and not on spreadsheet

[Guest]

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

 

[Jon Peltier]

You could have another range on the worksheet, out of sight, that
performs a sort of the data (use functions like LARGE in conjunction
with VLOOKUP or INDEX/MATCH). Chart based on the hidden data, but
display the unsorted data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thanks Jon but can you help me with the functions pls cos i am a fairly new
user and could do with some help.
Thanks again