more error bar option

Anonymous
2021-10-22T08:06:38+00:00

Hi I have the same problem as the attached link regarding error bars in excel. The 'more error bar options' has disappeared. I am using Excel 16.51 for Mac. It's very much appreciated if anyone can advice. Thanks!

https://answers.microsoft.com/en-us/msoffice/forum/all/more-error-bar-options/41bdfe9d-1eca-4d5c-952c-8125e05bc4ad

Microsoft 365 and Office | Excel | For home | MacOS

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

Answer accepted by question author

Anonymous
2021-10-22T12:45:27+00:00

Hi christinecheng,

As per your description, based on my test result the “more error bar” options is available in Excel version 16.54. See image below for your reference:

As you mentioned, “I am using Excel 16.51 for Mac” and you Office 365 version is not up-to date, so please first of all please make sure your Office apps are fully updated. The latest version of Office 365 for mac is 16.54.

Since you Excel version appears lower, you may manually update Office apps, click Help > Check for Updates from any of the Office app to get the latest build.

For some reason if Office apps still didn’t update, then please download the Update packagefrom this article, then open Excel file and check the outcomes.

May I know which chart type you are using? please make sure you are using Scatter Chart type.

Also, please try to operate a safe boot for Mac then the outcome. To operate the safe mode is to determine whether background programs are interfering with Office for Mac.

If issue still persist and issue with all Excel files even new created Excel document on your Mac OS, then I suspect components were corrupted somehow. You can go to the Applications folder In Finder and drag Microsoft Excel.app to the trash. Then Restart your Mac Download this installer Install package and use it to reinstall Microsoft Excel (the latest version 16.54). Then, restart your Mac and test.

If above suggestion does not work for you, please feel free to confirm your MacOS version.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-10-26T16:28:49+00:00

    It's solved now. Thank you so much!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-10-23T19:22:17+00:00

    Hi christinecheng,

    May I know have any updates regarding to this issue? Feel free to post back if you need further assistance.

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments