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.
Double-click the x-axis.
Under Axis Options, there should be a radio button to select Date axis.
HansVogelaar Thanks for your response, but "Date Axis" was already selected, and I switched back and forth to "Text Axis" and nothing changed.
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?
- Sorry about that, here you go: https://www.dropbox.com/scl/fi/8wlzbrht8l9sgv99d8e4u/WORK.xlsx?rlkey=5i6nqi0gsolgpaazufh7huott&dl=0
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.