Excel 2019 - Cannot Edit Horizontal Axis Labels

Anonymous
2021-04-11T11:41:31+00:00

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.

0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-04-11T11:46:37+00:00

    What happens if you click Edit under Legend Entries (Series)? Can you edit the Series X Values there?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2021-04-12T11:17:59+00:00

    Nope, it still displays the same window. I can't click it

    3 people found this answer helpful.
    0 comments No comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-04-12T12:24:57+00:00

    I meant this button - it appears to be enabled in your screenshot:

    1 person found this answer helpful.
    0 comments No comments
  4. 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

    2 people found this answer helpful.
    0 comments No comments
  5. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-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.

    0 comments No comments