Forum Discussion
Solved
I need the x-axis to stretch to reflect the different dates that pairs with the y -axis data
I have a collection of data — a date of survey and three values — throughout 10+ years and I need to graph it, three lines over time. I don't have entries at regular intervals, though. Some years, wi...
The header row was still text.
I did the following in the attached version:
- I selected the header row.
- I copied it.
- On a new sheet, I clicked the lower half of the Paste button and selected the option to transpose.
- The values were now in a column.
- On the Data tab of the ribbon, I clicked Text to Columns.
- I clicked Next >, twice.
- I selected Date, then DMY.
- I specified B2 as target.
- I clicked Finish.
- Column B now contained real dates.
- I copied those.
- I switched back to the Plan1 sheet.
- I pasted the data back transposed to a row.
Thanks! I can see your version works, but I cannot edit my own version to do the same.
I believe I have the header row data converted to dates. And the radio button "Date axis" is selected. I also believe I converted to range (although I don't know what it means).
The header row was still text.
I did the following in the attached version:
- I selected the header row.
- I copied it.
- On a new sheet, I clicked the lower half of the Paste button and selected the option to transpose.
- The values were now in a column.
- On the Data tab of the ribbon, I clicked Text to Columns.
- I clicked Next >, twice.
- I selected Date, then DMY.
- I specified B2 as target.
- I clicked Finish.
- Column B now contained real dates.
- I copied those.
- I switched back to the Plan1 sheet.
- I pasted the data back transposed to a row.
Thanks so much! Although I once again reproduced your steps to the letter, I wasn't able to succeed in editing my original sheet. Copying the values to a new sheet worked readily, though. I'll try to learn what is happening with it.
Really appreciate your attention!