Share via

XY scatter plot not using proper x values

Anonymous
2020-03-05T06:25:40+00:00

I don't know why - but I can't get the X-Axis of my scatter chart to display the correct values.  

Also, I can't create a chart that uses data from a different sheet.  I have to work around by first creating the chart in another sheet and then cut and paste.   

The main question is how to make the chart show the correct x-axis values.

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-05T10:15:50+00:00

    Check the formatting (or rather the source) of the data in A columns of your data sheets, i.e. the X-ranges. As the data are left adjusted I guess they maybe incorrectly formatted (or rather generated), maybe as Text. If not all data in the X-range are interpreted as a number, Excel will just use a default numbering (1, 2, 3, and so on) for the X-axis, and that is what you see in your scatter chart.

    Hope this helps / Lars-Åke

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-03-06T00:45:57+00:00

    @Lars-Åke Aspelin - That was the problem - the x-data was text, not numbers.   

    I imported a text file.   Not sure why the other two columns came in as numbers, but the first came in as text.  Weird.  But, now I know what to look for.

    Thanks!

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-03-05T08:08:34+00:00

    Login to https://onedrive.live.com/ (Use the same Login ID and password as for this forum).

    Click Upload in the top and choose your file.

    After uploading, right click the file and choose share.

    Click Get a Link.

    Copy the link and paste it here.

    Andreas.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more