Share via

Excel can't create charts

Anonymous
2019-01-12T21:44:31+00:00

I've been building charts for years and years in excel.   All types, thousands over the years.   I know how to do it through multiple versions of Excel.

I just moved to subscription for Office 365 on a new MacBook Pro.   The Excel build is 16.20 and I can't create charts.

I select the data fields for my chart, go to Insert - Chart and the chart type menu is greyed out and inoperative.   I can't create charts. 

Please help me fix this.   Its mission critical.   Thank you.

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

Answer accepted by question author

Anonymous
2019-01-13T11:30:37+00:00

Hi John,

To enable the Charts options, please click "Excel" in the top menu > Preferences > View > under "For Objects, Show", select "All". 

If the above method could not help, please provide us with the following information so that we could further assist you:

  1. Please create a new workbook and see if you could encounter the same issue in it;
  2. Please click "Excel" in the top menu > About Excel > capture a screenshot of the version information.

Regards,

Nathan

Nathan,

Preferences-View-Objects=Show All is the solution.    It worked.   Thank you very much.

I'd argue the product ship with "Show All" the default setting.

Thank you very much.

John

Was this answer helpful?

6 people found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-13T11:49:46+00:00

    Hi John,

    Thank you for your feedback. I'm very glad that it worked. If you have any other concerns when using Office 365, please come back and let us assist you.

    Best Regards,

    Nathan

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-01-13T11:32:15+00:00

    Hi

    Please go to the Excel menu and choose About Excel to display your product information. What is the license type?

    Office 365 Subscription

    Was this answer helpful?

    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2019-01-13T05:24:10+00:00

    Hi

    Please go to the Excel menu and choose About Excel to display your product information. What is the license type?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-01-13T04:31:55+00:00

    Hi John,

    To enable the Charts options, please click "Excel" in the top menu > Preferences > View > under "For Objects, Show", select "All". 

    If the above method could not help, please provide us with the following information so that we could further assist you:

    1. Please create a new workbook and see if you could encounter the same issue in it;
    2. Please click "Excel" in the top menu > About Excel > capture a screenshot of the version information.

    Regards,

    Nathan

    Was this answer helpful?

    0 comments