ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart league position (https://www.excelbanter.com/charts-charting-excel/65429-chart-league-position.html)

Rosie Carey

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.

Andy Pope

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