Forum Discussion
Solved
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 rearrange the data to match what I was describing I wanted earlier, but this still did not work the way I wanted.
Nateman123 Try it like in the attached file.
5 Replies
Nateman123 Try it like in the attached file.
- Thank you so much! I really appreciate your help.
Nateman123 Glad I could help!
- 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).
