Thread: Sort order for chart only and not on spreadsheet

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

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
>
>

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
> >
> >
>

John Mansfield has an example of this kind of chart on his blog,
http://pdbook.com/index.php/excel/

I'd find you the page, but the server says it's offline now. But you can
do what I would have done: search for the word "sort" on his site.

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


Dharsh wrote:

> 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
>>>
>>>
>>