Forum Discussion
I need the x-axis to stretch to reflect the different dates that pairs with the y -axis data
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, that is helpful.
The values for the x-axis are the header row of a table. The header values are always text, even oif they look like dates.
In the attached version, I converted the table to a normal range, then converted the text values to real dates.
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!