Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Allow Charts to use data from hidden cells

As of now, if you group and/or hide cells that contain data going to a visualization, the visualization goes blank. I'd like to be able to hide data without losing the corresponding visual.

5 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Kara T. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Scott Ruble (PM MSFT) responded  · 

We actually support this feature in versions of Excel back to XL 2007. Here are the steps.

1) Select the chart
2) from the chart “Design” tab in the ribbon click on the button “Select Data”
3) In the dialog, click on the button called “Hidden and Empty Cells”
4) In the dialog, check the box called “Show data in hidden rows and columns”

Thanks,
Scott [MSFT]

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi Scott,

    Is this function also works in treemap? Tried but seems the option cannot be selected like other charts.

    Regards
    Ada

  • Nicholas commented  ·   ·  Flag as inappropriate

    In the data selection area there is an option called "Hidden and Empty Cells" in there you can tick "Show data in hidden rows and columns". I'm not sure if you meant automatically default to this as ticket or have this option added.

Feedback and Knowledge Base