Graphing a data range

[Nateman123]

I am trying to graph a date range (1890-1910, 1910-2010, and so on) on the x-axis and measurements on the y-axis. However, every time I do this the dates do not work on the x-axis. I have tried to rearrange the data to match what I was describing I wanted earlier, but this still did not work the way I wanted. 

 

[#2]

that is because "20mm" is TEXT and not a numeric value. Convert that column to be just the numbers: 20, 15, 50, ... and try again

[#3]

Thank you! this solved the problem of it not graphing. Now, I have the problem of the x-axis showing 0-7 instead of the proper years. (I am sorry I am new to excel).

[#4 · Accepted solution]

@Nateman123 Try it like in the attached file.

[#5]

Thank you so much! I really appreciate your help.

[#6]

@Nateman123 Glad I could help!