Share via

Chart Element

Anonymous
2018-09-08T19:28:01+00:00

Me and my mom are trying to display the chart element on my MacBook Air. We keep clicking the charts but nothing show up. Why is this hapining?

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
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-09-10T18:16:24+00:00

    Hi

    In order to keep the interface cleaner, in Excel for Mac the button is on the Ribbon. Click the Add Chart Element button on the Chart Design tab of the Ribbon for the options you are looking for.

    My personal preference is that I don't like the button attached to the chart. However, many Office for Mac users come from Windows and are used to it being there.

    Microsoft has a forum devoted to feature requests and interface design suggestions. I looked through the forum and didn't see a request to have the Elements button display, so you may wish to start a new request. Here's a link to the forum.

    Excel for Mac

    2 people found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-09-09T01:10:01+00:00

    Hi Jordon,

    The green "+" plus button for Chart Elements is available in Excel for Windows. In Excel for Mac 2016, we could click the chart, Chart Design and Format tabs will appear. Under Chart Design tab, we could click Add Chart Elements to show/hide elements. Meanwhile, we could also directly select a chart layout via click Quick Layout button.

    Regards,

    Tim

    0 comments
  2. Anonymous
    2018-09-09T01:16:37+00:00

    Thank You Tim, and one more thing. How can you filter a chart?

    0 comments
  3. Anonymous
    2018-09-09T02:20:44+00:00

    Hi Jordon,

    Excel for Mac doesn't have the similar Chart Filter button as Excel for Windows. If you want to let the chart display selected data as using filter, you could manually filter a column or click Select Data button under Chart Design tab. To learn more, see Change the data series in a chart.

    Thanks for your understanding.

    Tim

    0 comments