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
"Jon Peltier" wrote:
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/
_______
Dharsh wrote:
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