Share via

How to hide columns or rows in excel but still keep the data in a chart showing

Anonymous
2023-01-11T11:20:39+00:00

Hi,

I have set up some charts in excel now I want to hide the rows / columns where the original data sites so that people can just see the charts however whenever I hide these the data in the chart disappears.

I have googled how to do this and it's telling me to select the data, and press the button that says hidden and empty cells. I done this where the cells are not yet hidden and after I have hidden then however this button still stays blocked out and unable to select.

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

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-11T15:59:11+00:00

    thanks :)

    0 comments
  2. Anonymous
    2023-01-11T16:12:15+00:00

    If you could link to the file please.

    Charts linked to Pivot tables do this but usually hidden rows/columns are plotted anyway.

    What kind of thing is the source data for the chart? A range, a query, Power Pivot?

    0 comments