Excel 03 - Charts

  accord 16:35 27 Jul 2004

I am wanting to create a chart whereby the data is shown upside down. ie a league table where 1 is at the top and 100 is at the bottom.

I am having trouble doing this so any suggestions.

Thanks in advance for your help

  xania 16:48 27 Jul 2004

If I understand you correctly, the answer is quite simple. Having entered all the data, you now need to sort (data drop down menu) on the column which shows the total points gained. You will need to sort all columns (naturally) in decsending order, excluding the header row, et voila!!

  accord 16:54 27 Jul 2004

sorry perhaps i didnt quite explain fully,

i require no 1 to be at the top of the Y axis (left hand column) and no 100 at the bottom. On the X axis I require the team to be dispayed.

All i seem to get is no 1 at the bootm and no 100 at the top.

Xania: thanks anyway I have tried that but doesnt give what i want.

If you right click on the X axis figures you can choose to Format axis.

At the bottom there is the option to place the values in Reverse order and also that the X axis crosses at the maximum value; both of these should be checked.



  xania 09:23 28 Jul 2004


I think you've missed the main point. If you look at your sort screen, against each field you can select which order you want - it defaults to ascending. You need to sort Descending.

  xania 09:26 28 Jul 2004

If this is not what you need, I need to see the problem. Please e-mail me directly a copy of your spreadsheet and I will see what can be done.

  accord 11:00 28 Jul 2004


it works the way you advised


thanks for your input and time

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

See iconic duo Smith and Foulkes' epic animation for the BBC's Winter Olympics coverage

iMac Pro review

Idées cadeaux pour geeks et tech addicts