LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort order on very large spreadsheet. Dennis1188 Excel Discussion (Misc queries) 4 May 31st 07 05:32 PM
Can I save a custom sort order for a specific spreadsheet? BarKay Excel Worksheet Functions 1 March 14th 07 03:19 PM
how do I set up a excel spreadsheet to auto sort data in order jason Excel Discussion (Misc queries) 0 January 3rd 06 07:17 PM
Sort order for chart only and not on spreadsheet Dharsh Charts and Charting in Excel 3 May 27th 05 03:38 AM
Sort order for graph only and not spreadsheet Dharsh Excel Discussion (Misc queries) 2 May 25th 05 12:40 PM


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"