Share via

Changing axis bounds maximum and minimum

Anonymous
2021-03-21T09:42:34+00:00

Hello,

I need to format axis bounds with different range. However, when I double click to visit the axis options I am given the option to change the bounds yet when ı enter the max or min number the plot stay same. 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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2021-03-21T13:55:43+00:00

    I’ve used your data to set up a X Y (Scatter Chart) Scatter with Straight Lines and Markers.

    I’ve then changed the Bounds (see screen shot below) and the chart updates correctly.

    I don’t know how / if you’ve incorporated your slope / intercept and Rsq data into the chart: perhaps this is the cause of the behaviour you’re reporting?

     Image

    0 comments
  2. Anonymous
    2021-03-21T15:04:36+00:00

    Thanks for your answer.

    Unfortunately, when ı just plot the graph without any rsq value, still same situation. ı just enter 40 as a max value and it didn't change.

    0 comments
  3. Anonymous
    2021-03-21T15:13:37+00:00

    If ı will share my screen with you, it would be really helpful. Also I think there is problem about "Auto" options indeed. maybe that is the reason why ı can not change the range.

    0 comments
  4. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2021-03-21T16:55:15+00:00

    If ı will share my screen with you, it would be really helpful. Also I think there is problem about "Auto" options indeed. maybe that is the reason why ı can not change the range.

    I don't know why things aren't working at your end: perhaps somebody more expert than myself can help?

    0 comments
  5. 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