What happens if you click Edit under Legend Entries (Series)? Can you edit the Series X Values there?
Excel 2019 - Cannot Edit Horizontal Axis Labels
Hello,
I'm having some problems in trying to label the x axis on a table.
The chart displayed the correct points needed. However, the axes displayed is the number of data points (which is about 1500 points) instead of the chosen x axis data, which is supposed to be in the range of 0-30 seconds.
I tried to edit the horizontal axes labels in the select data source window, but the option cannot be clicked.
Does anyone has a way out of this?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
6 answers
Sort by: Most helpful
-
-
HansV 462.4K Reputation points MVP Volunteer Moderator2021-04-12T12:24:57+00:00 -
Anonymous
2021-04-12T22:21:30+00:00 yes you can, but it doesn't change the horizontal axis display that I wanted. It just chooses the data for the horizontal and vertical axes
-
HansV 462.4K Reputation points MVP Volunteer Moderator2021-04-13T07:13:44+00:00 Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.