Excel Horizontal Axis Formatting When "Bounds" Option does not appear

Anonymous
2020-03-25T04:06:13+00:00

Hello,

I need to format my horizontal axis with different spacing and boundary conditions. However, when I double click the horizontal axis and visit the axis options I am not given the option to change the bounds or spacing. Please advise on how to get around 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

1 answer

Sort by: Most helpful
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2020-03-25T16:00:39+00:00

    Use a scatter chart instead of a line chart to get that options.

    Andreas.

    29 people found this answer helpful.
    0 comments No comments