Help With Excel 2013

[chasehornby55]

i am creating a basic combo chart in excel that shows populations of wolfs and deer over time. my x axis is suppose to be from 1991-2000 however i am unable to change the x axis data. i have tried everything. i tried selecting the data and when i do that the "select data source" box says my horizontal axis lables should be 1991-200 however when i click ok they stay 1-10. please help me i need this for school.

 

[Joeteoh99]

Have you made a table?

For example X axis on the first column and Y axis on the second column. Then I would highlight the data and make it as a table (I am pretty confident you know how to do that).

Then if a data needs to be change or modified, just change the table.

 

[chasehornby55]

My issue is i am using 2 vertical axis which seems to be the source of my issue.

 

[Joeteoh99]

Try the table format and have only two columns one for x and the other for y.

 

[chasehornby55]

Haha i had to have 3 different axis's because one set of numbers was around 50 when the other was around 5000. my issue was i had the word year above the years which made excel think it was another data set.