Forum Discussion
Solved
Excel convert text to year
I copied data from https://www.metoffice.gov.uk/hadobs/hadcet/cetml1659on.dat to an excel sheet To plot it I need to convert the first columns to year. Googled online, no clear answer. I tried seve...
- Thanks. Let me digest it for a day or two. It looks like excel has changed since the last version I used, that was from early 2000s. Thanks again
That far I know. I highlighted on columns, CNTR -key, moved to the to the other one, highlighted that one. But afterwards, I clicked Insert and pick a graph from the options given and got some nonsense.
Mike_Kova Okay. Start by just selecting the data for the line. In my example N2:N364. Now on the Insert ribbon select the type of chart, say a line. That should instantly produce this:
Now click on the axis and in the Chart Design ribbon, Select Data.
Press edit in the right-hand window for the horizontal axis labels and enter :
=Data!$A$2:$A$364 or just select the range with the mouse.
OK.
The rest is formatting.
- Thanks. Let me digest it for a day or two. It looks like excel has changed since the last version I used, that was from early 2000s. Thanks again
- Seems to work. Thanks. I tired to "like" your answer but instead somehow marked my question as a solution. I have no idea what I did wrong. I guess I am too old for new technology. Again, thanks for your help.
Mike_Kova No problem. You must have marked it yourself. Perhaps accidentally, because your name is on it.
I believe only you can unmark it yourself. How, I don't know. Never done it. And liking is done by pressing on the thumbs-up icon, not by pressing on the word "Likes!.