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 Perhaps easier to see when you move the chart into the Data sheet. Then select the chart and you'll see the ranges that selected for the line and axis labels. In the example, I took N2:N364 for the line and A2:A364 for the axis labels.
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.
- Instead of one graph, I get two graphs in two different colors, neither is correct.