Excel Guides

Hiding Graphics when Filtering in Excel

When you filter data in Excel, the graphics associated with that data can sometimes get hidden from view. This can be frustrating, especially if you've spent a lot of time creating those graphics. Luckily, there are a few ways to work around this issue.

One way to ensure that your graphics don't get hidden when you filter is to create them on a separate worksheet. That way, when you filter the data on your main worksheet, the graphics on the other sheet will remain visible. You can then use a reference to link the graphic to the data on your main sheet.

Another way to keep your graphics visible when filtering is to use conditional formatting. With conditional formatting, you can specify that certain cells should be highlighted or have a different fill color when they meet certain criteria. For example, you could set it up so that all cells containing data that's being filtered are highlighted in red. That way, you can easily see which cells are being affected by the filter.

You can also use shapes or images instead of traditional charts and graphs. This can be a good option if you want more control over how your graphics look. Shapes and images can be inserted into cells, so they'll move along with the rest of the data when you filter it. Just be sure to size them appropriately so they don't get cut off.

Finally, if you're using an older version of Excel, you may be able to take advantage of the Subtotal feature. This allows you to create a list of all the items that are being filtered out, which can be helpful for troubleshooting purposes. To use this feature, select the data you want to filter, then go to Data > Subtotal. In the dialog box that appears, choose what type of subtotal you want to create and what column you want to subtotal. Then click OK.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.