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.
Sorry, your screenshot is so small that my old eyes cannot read it.
Could you attach a stripped-down copy of the workbook without sensitive data, or upload it to OneDrive, Google Drive, Dropbox or similar, and post a link to the file in a reply?
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.