Sign in with
Sign up | Sign in
Your question

Help With Excel 2013

Tags:
  • Apps
  • Office 365
  • Axis
  • Excel
  • Basic
Last response: in Apps General Discussion
Share
September 14, 2014 9:28:22 PM

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.

More about : excel 2013

September 14, 2014 9:32:26 PM

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.
m
0
l
September 15, 2014 7:06:00 PM

My issue is i am using 2 vertical axis which seems to be the source of my issue.
m
0
l
Related resources
September 15, 2014 7:28:44 PM

Try the table format and have only two columns one for x and the other for y.
m
0
l
September 15, 2014 7:32:03 PM

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.
m
0
l
!