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
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.
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
- Instead of one graph, I get two graphs in two different colors, neither is correct.