+ Reply to Thread
Results 1 to 4 of 4

How to get Dynamic Target/USL/LSL lines in Quality Dimension Pivot Chart

  1. 01-28-2019, 09:11 AM #1
    abawari3007
    abawari3007 is offline
    Registered User
    Join Date
    01-25-2019
    Location
    Guwahati
    MS-Off Ver
    365
    Posts
    2

    How to get Dynamic Target/USL/LSL lines in Quality Dimension Pivot Chart

    Hello All,
    Let me explain my Workbook:
    Sheet 'Master': where we input the Item > Mold details
    Sheet 'SPEC SHEET': where we input the dimension details for each Item
    Sheet 'INPROCESS RAW': where the operator takes different dimensions for different items and enters the raw value

    My Goal:
    To plot a pivot (or dynamic non-pivot) chart where I can choose the different items, molds, dates, cavities and it plots the raw/target/USL/LSL values.

    Prob with current chart: The TGT/LSL/USL values are repeating for each data point and causing a clutter in the chart. For high volume these repetitions will make it unreadable.
    Cluttered Chart.JPG

    Is there any way the TGT/LSL/USL lines are plotted only once but keep chaning as I change the slicer?

    Thanks in advance!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-28-2019, 06:16 PM #2
    dflak
    dflak is online now
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: How to get Dynamic Target/USL/LSL lines in Quality Dimension Pivot Chart

    This seemed like an interesting project to get me working with charts again.

    The event runs when the pivot table is updated (which is what the slicers do). The event runs a program that looks at all the series after the last 5 and deletes them if they match *Tgt or *Limit. That leaves only the original target and control limits and all actual values.

    I looked up how to change the text on the legend entry to see if I could change the name from 1/10/2019 Tgt to Tgt, etc. but it can't be done.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 01-30-2019, 12:57 AM #3
    abawari3007
    abawari3007 is offline
    Registered User
    Join Date
    01-25-2019
    Location
    Guwahati
    MS-Off Ver
    365
    Posts
    2

    Re: How to get Dynamic Target/USL/LSL lines in Quality Dimension Pivot Chart

    Hi dflak,
    Thanks for the immediate help.

    Not sure what am I doing wrong but the pivot chart does not show any thing. I tried clicking update button too.
    Reply With QuoteRegister To Reply
  4. 01-30-2019, 10:42 AM #4
    dflak
    dflak is online now
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: How to get Dynamic Target/USL/LSL lines in Quality Dimension Pivot Chart

    I don't know what update button you are talking about. The event is run when the pivot table is updated which happens when the slicers are selected.

    If the result of the pivot returns NO data, then the chart is blank. There are slicer combinations where this happens.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic target line in Pivot Chart?
    By iadrika21 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 03-11-2018, 08:49 AM
  2. Chart with Target Lines
    By kittu55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2017, 12:31 PM
  3. Adding a Dynamic "Target Threshold line" to a Pivot table and chart
    By ImokatExcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2016, 03:02 PM
  4. Retaining horizontal target lines in vertical column graphs after filtering in pivot chart
    By bargainofoz in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-05-2015, 09:08 AM
  5. Horizontal bar chart with target lines
    By golfoscar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-08-2014, 03:57 AM
  6. [SOLVED] Working out Percentage needed in quality checks to hit average target
    By smattless in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2014, 05:42 AM
  7. Bar chart with 'target' lines but target varies per column
    By Ineedcoffee in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 11-24-2011, 05:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1