Chart Design Tab is now missing on Excel for Mac

Since the latest Microsoft Office update, I have not been able to find out how to edit a chart. There used to be a tab that would show up when i selected a chart, but now nothing appears.
The only way I can seem to get that tab to show is if, when I have my 2d pie chart selected, I change the "recommended charts" dropdown to "Pareto". Doing this also erases all the content in the chart and I have no way to change it back.

If you need context as to what I'm trying to do, I'm attempting to get my legend items to appear on the pie chart itself, which I have been able to do numerous times prior to this via the chart design tab.

Help!

I'm on Microsoft Excel for Mac, Version 16.9.
 

Question Info


Last updated September 22, 2019 Views 5,610 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Could you update your OS to latest also? Usually latest OS and latest Office work good. Also try to update your Office so that if any patch is released by Microsoft that would flow in.

It is also possible that latest version of Office has this bug as many issues are being reported in this new version.

I would suggest that you should post simultaneously to Technet forum also as this will be looked into by MS Product team also. So, your question will be on two forums - This and Technet.
https://social.technet.microsoft.com/Forums/off...
Best regards
Vijay Verma

Timezone: UTC+05:30, PST+12:30
Availability Hours (UTC) : 05:00 AM - 05:00 PM

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

As you know, the chart design tab should appear automatically whenever the chart is selected. Have you restarted your Mac since updating? If not, please try that. You can also display the formatting pane by right-clicking on the chart and choosing Format Chart Area.

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

My work IT dpt. won't let me update OS yet :( But, I am on the latest microsoft office version.

Posted in Technet as well now, thanks for the suggestion!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Restart did not work unfortunately. I clicked around the format chart area panel but I couldn't find the option to add legend info on the pie chart itself rather than on the side :/

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Carly,

 

To troubleshoot the issue, please help to provide the following information:

1.Is Chart Design tab missing when you create a specific Chart type in Excel? Please try creating charts with other types and check the outcome.

 

2.When you right click the chart and choose Format Chart Area, can you see the Format Chart Area pane showing in the right side of the workbook?

If you cannot see the pane, please capture a related screenshot to describe the situation on your side.

 

3.Please also provide a related screenshot when you select a chart while the Chart Design tab doesn't show up.

 

4.Does the issue happen in a specific workbook or all workbooks? Please create a new workbook and check the result.

 

5.Your Mac version. (Apple menu>About this Mac)

 

Note: to protect your privacy, please mask any personal or private information in the screenshots before sharing.

 

Regards,

Tina

-------------------------------------------
If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Carly,

Are you still experiencing the issue? Could you provide the requested information for investigation?


Regards,

Tina

-------------------------------------------
If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

1. It's when I create any chart using data selected from a pivot table.

But when i create any chart from just mock data typed in, it works

2. I can see the format chart area pane when I right-click, but it does not allow me to incorporate the legend in the chart (like I did on the second screenshot above)

3. The first question has screenshots relevant to this question

4. Looks like this issue is happening ONLY when trying to create charts using data from a pivottable. This is happening with both a brand new workbook and with the workbook that I originally was seeing the issue with.

5. Mac version and info:

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Carly,

Thanks for your update and detailed information.

We'd like to explain that if we create a chart using the data from a pivot table in Excel 2016 for Mac, when clicking the chart, the Chart Design tab and Format tab are not available in the ribbon.

Given this situation, we welcome and suggest you send feedback to Excel for Mac uservoice to help improve our products and service. This is the best way to let related team hear your voice and make our products better for you and others.

Your understanding will be highly appreciated.

Regards,

Tina

[Updated by Tina Chen MSFT, Feb 1st, 12:34 PM (UTC)]

-------------------------------------------
If you feel a reply works for you, please kindly vote or mark it as it will be beneficial to other community members reading this thread.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Carly,

Thanks for your update and detailed information.

We'd like to explain that if we create a chart using the data from a pivot table in Excel 2016 for Mac, when clicking the chart, the Chart Design tab and Format tab are not available in the ribbon.

Given this situation, we welcome and suggest you send feedback to Excel for Mac uservoice to help improve our products and service. This is the best way to let related team hear your voice and make our products better for you and others.

Your understanding will be highly appreciated.

Regards,

Tina

 Hey Carly, 

   I am having the same issue and it it really causing me issues when trying to create reports that I have borrow a different laptop just to get produce reports I had easily created before. 

Tina: This make no sense whatsoever. This functionality works perfectly fine on versions before this latest update. I have tried making these charts on version 15.19 and this is the only way I am able to complete my job. Something is wrong with the latest update.  

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I agree, if the function was there before, then why would it not be in this version?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.