![]() |
Chart league position
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. |
Chart league position
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 |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com