#1   Report Post  
Dharsh
 
Posts: n/a
Default Plotting Graphs

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
every time I update the score (automatically) without me having to change it
everytime I do it.

Can anyone pls help me plssssssssssss

Thanks so much in anticipation

Dharshanie
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Are you able to make a Bar or Column chart without worrying about the order?
Tell us the answer, and I will show you how to order the data. Can we assume
there will always be 4 scores?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dharsh" wrote in message
...
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
every time I update the score (automatically) without me having to change
it
everytime I do it.

Can anyone pls help me plssssssssssss

Thanks so much in anticipation

Dharshanie



  #3   Report Post  
Dharsh
 
Posts: n/a
Default

Thanks for your reply Berbard. I can make a column or a bar chart without
worrying about the order but here, I want to make the chart in order of
score, in this case from highest to lowest but want to keep my spread sheet
looking AB,B,C,D . . . .

No, I don't have 4 entries. I have 32 entries.

Hope this is sufficient. Thanks again for the prompt reply. Awaiting
another reply
Thanks
Dharsh


"Bernard Liengme" wrote:

Are you able to make a Bar or Column chart without worrying about the order?
Tell us the answer, and I will show you how to order the data. Can we assume
there will always be 4 scores?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dharsh" wrote in message
...
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
every time I update the score (automatically) without me having to change
it
everytime I do it.

Can anyone pls help me plssssssssssss

Thanks so much in anticipation

Dharshanie




Reply
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
plotting a single line graph plotting graphg New Users to Excel 0 February 26th 05 10:21 PM
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) Hari Prasadh Charts and Charting in Excel 4 February 17th 05 02:44 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Hatchet_Jack Charts and Charting in Excel 1 February 9th 05 10:31 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Bearclaw Chris Charts and Charting in Excel 0 February 9th 05 04:59 PM
Graphs and sheet referencing? Graham Excel Worksheet Functions 2 October 31st 04 11:37 PM


All times are GMT +1. The time now is 03:16 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"