PivotChart - add Expand/Collapse button?

Anonymous
2017-07-20T15:48:19+00:00

I created a PivotChart where I can collapse the x-axis (months) with a button on the chart (bottom right corner):

The result is this:

But I also want to be able to collapse and expand the country selection on the right hand side. It is possible to do that via right click:

Is it possible to include an expand/collapse button like in picture 1 for this dataset (country/city) as well?

Thanks!

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 No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2017-07-21T07:06:58+00:00

    Hi KLM_735,

    The Expand/Collapse button isn’t available in the Legend(Series) area now. I suggest you submit your feedback on our Excel UserVoice as it is the direct way for product developers to know users’ requirements.

    Thanks,

    Cliff

    0 comments No comments

0 additional answers

Sort by: Most helpful