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. I'm on Microsoft Excel for Mac, Version 16.9. Hi Carly, >> There used to be a tab that would show up when i selected a chart, but now nothing appears. By 'a tab', do you mean the Chart Design tab when selecting the chart? I did much research but currently haven't see other users reporting the issue and didn't find any documentation stating if this is a known issue in 16.9 either. But when testing in my Excel 2016 for Mac (16.10, ), the Chart Design tab can show up properly: Did this issue start since you install the recent update?

Join Curt Frye for an in-depth discussion in this video, Changing chart types and layouts, part of Excel for Mac 2016 Essential Training. Where is Chart Tools in Microsoft Excel 2007, 2010, 2013, 2016 and 2019. However, the Chart Tools seem be hidden in Ribbon. Here offers two methods to find out the Chart Tools in Microsoft Excel 2007, 2010, 2013, 2016 and 2019. Select the chart, and then Design tab, Layout tab, and Format tab appear in the far right of Ribbon.

What's the detailed build number of your Excel 2016 for Mac (for example Build 18011602)? Best regards, Yuki Sun Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact.

Click to learn more. Visit the dedicated to share, explore and talk to experts about Microsoft Teams. Also happening to me. Drive utilities for mac os x sierra. Excel 16.9 (180116) Chart Design does not appear when a chart is selected. Edit: Can confirm this is only once it has been set to reference a pivot table. Creating a new chart and selecting an option from the Quick Layout menu, then referencing a pivot table will result in what I want.

I'm also able to copy the legend element from a chart that has one and paste it into an existing chart (which doesn't otherwise give me access to Chart Design). Unfortunately this appears to copy ALL formatting of the chart. Hi Carly and creacha, We have seen some similar reports about the issue and have submit this using our internal way. Please check and confirm if it is the same as your scenario. Since the issue cannot be reproduced in 16.10 during my test, I am assuming that this should be an temporary problem. For now, the workaround can be joining in Office Insider to bypass the issue.

Sorry for any inconvenience and thanks for your patience. Best regards, Yuki Sun Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact.