chasehornby55

Estimable
Jun 23, 2014
13
0
4,560
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

Estimable
Herald
Jul 20, 2014
282
0
5,210
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

Estimable
Jun 23, 2014
13
0
4,560
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.