Forum Discussion
Excel convert text to year
- 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 Why would you want to convert the first column to "year". It's just going to be an axis label, unless you have something else in mind. Attached a file with the data you referred to and a simple line chart for the average yearly temperatures. The years are on the horizontal axis, based on the first column in the data tab.
Riny_van_Eekelen Thank you so much for replying. I have tried to plot the graph but for whatever reason could not get it right. Would you please describe how you got the plot. Thank you so much in advance
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.