+ Reply to Thread
Results 1 to 1 of 1

Chart Slicer & Labels/Marker Formatting Issue

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

    Chart Slicer & Labels/Marker Formatting Issue

    Hoping the community can lend a hand here, because I'm driving myself crazy...

    I have a chart in the Test workbook attached that is a combo chart of clustered bars and xy-scatter. The chart displays open trade space of various products in development. The slicers allow users to filter the chart (and back-end Excel table, NOT Pivot Chart) to show only products they are interested in. This seems to work, except for the previous formatting of labels and markers of the chart are broken.

    For example, applying no filter to the product set shows the chart in its correct form. However, applying 'Yes' slicer filter under the 'Filter Preset' slicer group, and then resizing the chart with the 'Update Trade Space Chart Size' button reflects missing/inaccurate label and marker formatting. If the slicer filters are then all removed, and the 'Update Trade Space Chart Size' button is again selected, the label and marker formatting is returned to its correct state.

    Any thoughts from the collective? I'm thinking it may be an Excel chart cache issue, but unsure at this point.
    Attached Files Attached Files
    Last edited by mcmahobt; 05-06-2020 at 08:53 AM.
    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. Replies: 1
    Last Post: 06-12-2019, 03:48 PM
  2. Replies: 1
    Last Post: 12-23-2018, 12:37 PM
  3. [SOLVED] Pivot chart slicer/date formatting
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2016, 05:07 PM
  4. [SOLVED] Dynamic chart ranges based on formula- Issue on labels
    By james444 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2015, 12:12 AM
  5. Pivot Chart Secondary Axis Issue with Slicer
    By bbr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-20-2014, 05:57 PM
  6. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  7. scatter graph and marker labels with multiple series
    By tkotko123 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-01-2011, 05:29 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