+ Reply to Thread
Results 1 to 2 of 2

Prevent filter of adjacent cells/area/charts on sheet while maintaining slicer and group

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Virginia Beach, VA
    MS-Off Ver
    O365
    Posts
    19

    Prevent filter of adjacent cells/area/charts on sheet while maintaining slicer and group

    I have a table on Executive_Drill sheet and a Dashboard of that data on another sheet (Dashboard) that presents charts manipulated by slicers based on Executive_Drill and a manual table that references summary data from Executive_Drill. I want to move the charts and tabled data from Dashboard to Executive_Drill in adjacent columns (e.g., CA:CH) next to the table. I want the charts and summary table to not be impacted by slicer filtering. Also, I want the charts and summary table moved to Executive_Drill in adjacent cells to the table to not be affected by Grouping hiding.

    I have managed to move most of the charts successfully to adjacent cells on Executive_Drill using workarounds, show data in hidden rows for the charts, and chart properties do not move or size with cells. However, I have remaining issues with the slicers filtering the added adjacent table (Dashboard B2:F11) and one chart (Workstation by Type Delivered) which will not display its data if the grouping is hidden due to it not being based on the summary table or workaround (placing results outside the Executive_Drill table).

    Any help is appreciated. Is there a way to prevent grouping from impacting the chart without having it incorporate hidden data and the slicers continuing to work? Is there a way to not hide the summary table that would be adjacent to the Executive_Drill table when slicers fields are chosen. The file is 20MB but screen shots attached.
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,389

    Re: Prevent filter of adjacent cells/area/charts on sheet while maintaining slicer and gro

    Filters hide entire rows - and anything that is in those rows - thats how filters work.

    If you are losing parts of a chart or table, move them to where they will not be impacted by a filter.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Move data from specific cell to other cells within that group in the adjacent column
    By luajambeiro in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2019, 12:25 PM
  2. [SOLVED] shift+space only working on the last group of adjacent cells
    By hard_cell in forum Excel General
    Replies: 3
    Last Post: 07-03-2019, 02:53 AM
  3. [SOLVED] How to prevent cell formatting from being copied to adjacent cells
    By Bradex in forum Excel General
    Replies: 5
    Last Post: 09-07-2017, 08:23 AM
  4. Find cells containing text, but group them at top of adjacent column
    By stanbridge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2016, 08:36 PM
  5. Filter in Adjacent Sheet
    By faisal.ta in forum Excel General
    Replies: 4
    Last Post: 10-04-2014, 10:53 AM
  6. Area charts and blank cells
    By Pat in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2005, 02:05 PM
  7. Blank cells represented in area charts
    By cdoughty in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2005, 01:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1