Chart league position

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a line graph which shows a teams position after each
game played during a season. I have managed to reverse the numbers on the
side axis to enable 1 the top position to be at the top, but this also moves
the bottom axis numbers to the top which I don't want to happen, I want the
number of games played to remain at the bottom of the graph. I am using
Excel 2002 version 10.2614.2625.

It seems such a simple request to do but I just cannot fathom out how to
create this chart which you see in the newspaers all the time.

Can anybody help me please.
 
Hi,

Assuming you double clicked the y axis and changed 'Values in Reverse
Order' to get the 1 at the top. Also check the 'Category (X) axis
crosses at Maximum' to keep the x axis labels along the bottom.

Cheers
Andy
 
Back
Top