Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort data for graph only
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 | |||
What formula will sort data in a separate worksheet%3f | Excel Worksheet Functions | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How do I sort row data without row fill color moving as well? | Excel Worksheet Functions | |||
Data - Sort Options | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel |