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

Rosie Carey wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info