Forum Discussion
Nateman123
Jan 22, 2022Copper Contributor
Graphing a data range
 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 re...
- Jan 22, 2022
Nateman123 Try it like in the attached file.
 
mtarler
Jan 22, 2022Silver Contributor
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
Nateman123
Jan 22, 2022Copper Contributor
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).