+ Reply to Thread
Results 1 to 1 of 1

Preserve Chart Label post-Filter

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Preserve Chart Label post-Filter

    Hello community,

    Having issues with preserving label formatting after applying a filter to a chart's underlying data.

    The 'Requirement Trade Space' worksheet's chart is based upon the 'Reqt Trade Space Settings' data table. When a slicer (filter) is selected, some label formatting is not preserved, altering the look of the chart which is not preverable.

    Example: Select 'Yes' from 'Filter Preset' slicer group > run 'Update Trade space Chart Size' macro to resize filtered chart > Test4 label placement has changed from the previously unfiltered chart.

    Any thoughts on how to prevent this from occurring on filters?
    Attached Files Attached Files
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  2. Replies: 6
    Last Post: 01-07-2014, 03:24 PM
  3. Filter Pivot Table Row Label by Another Row Label
    By bdcelli in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2013, 12:57 PM
  4. Pivot chart - can I label filter and Top 10
    By MorganW in forum Excel General
    Replies: 1
    Last Post: 05-10-2011, 01:50 AM
  5. Pivot Chart - Preserve Colours
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2009, 07:27 PM
  6. Trying to preserve label format (color) when refreshing
    By easycapital in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2008, 06:47 PM
  7. Preserve formatting in Pivot Chart
    By Craig in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2006, 10:25 AM

Tags for this Thread

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