Graphing a data range

New Contributor

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. 

Screen Shot 2022-01-22 at 11.42.03 AM.png

5 Replies
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
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).
best response confirmed by Nateman123 (New Contributor)

@Nateman123 Try it like in the attached file.

Screenshot 2022-01-22 at 18.15.58.png

Thank you so much! I really appreciate your help.

@Nateman123 Glad I could help!