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
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!.
- I am trying to post another question but somehow I can't so I figured maybe I ask you. I got a file from https://cneos.jpl.nasa.gov/fireballs/ , After removing all columns but the first one, I am left with just the first column with a list of dates of fireballs. How do I count how many fireballs were in each month? Thanks.