|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-24-2005, 11:06 AM
|
|||
|
|||
|
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 
|
|
#2
05-24-2005, 02:06 PM
|
|||
|
|||
|
Re: Sort order for chart only and not on spreadsheet
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 > >
|
|
#3
05-25-2005, 06:31 AM
|
|||
|
|||
|
Re: Sort order for chart only and not on spreadsheet
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 > > > > >
|
|
#4
05-27-2005, 12:05 AM
|
|||
|
|||
|
Re: Sort order for chart only and not on spreadsheet
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 >>> >>> >>
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
