Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort order for graph and not spreadsheet (dynamic)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort order on very large spreadsheet. | Excel Discussion (Misc queries) | |||
Can I save a custom sort order for a specific spreadsheet? | Excel Worksheet Functions | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
Sort order for chart only and not on spreadsheet | Charts and Charting in Excel | |||
Sort order for graph only and not spreadsheet | Excel Discussion (Misc queries) |