Forum Discussion
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, will have ten entries and some will have one entry or no entry at all. So I need the x-axis to be of regular length, yearly. (sorry about my phrasing)
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.
8 Replies
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?
