PICK-Chart.xlsx

VN:F [1.9.22_1171]
Rating: 4.8/5 (8 votes cast)
Add Comment


Author: © Eric Dayal

Download Now: PICK-Chart.xlsx

Description:

Most PICK Chart templates require you to manually place the idea onto the chart.  This template uses the Scatter Chart functionality in Excel to automatically place the ideas on the chart for you based on the the values you enter for Impact and Effort.  0 is the minimum value (low) and 3 is the maximum value (high)

The PICK Chart is a Lean/Six Sigma tool used to help prioritize ideas.  The X axis represents the Effort to implement an idea while the Y axis represents the expected Impact.  

Four quadrants are displayed in the PICK Chart:

  • Possible - ideas that are considered "low hanging fruit". The effort to implement is low, but the impact is also low.  These should only be implemented after everything in the "Implement" quadrant.
  • Implement - ideas that should be implemented as they will have a high impact and requrie low effort
  • Challenge - ideas that should be considered for implementation after everything in the "Implement" column.  The impact is high, but the effort is also high. 
  • Kill - ideas that should be "killed" or not implemented.  The effort to do so is high and the impact is low.  

A PICK Chart is typically used in a Lean/Six Sigma project after Problem Identification Waste Analysis and Root Cause Analysis.  




Related Docs:

  • FMEA-Template.xlsx
  • One-Page-Project-Charter.pptx
  • SIPOC.doc
  • 5w2h.docx
  • SIPOC-Visio-Template.vsd

  • Tags: ,,,


    Was this document helpful? Rate it Now

    PICK-Chart.xlsx, 4.8 out of 5 based on 8 ratings

    Date Posted: 2014-01-03 18:48:21

    2 thoughts on “PICK-Chart.xlsx

    1. I’d caution against too many items in the PICK chart. 12 is quite a bit to begin with. Often times, it helps to group projects/ideas into “bundles” and prioritize those. That being said, here is how you add additional items in this template:

      1. Add an “Idea 13” in the table, along with an effort and impact score.
      2. Right Click the Chart and choose “Select Data”
      3. Press the “Add” button under Legend Entries
      4. In the “Series Name” section, press the button next to Select Range, then click on the cell where you entered “Idea 13”, then press the Select Range button again.
      5. In the “Series X Values” section, press the button next to Select Range, then click on the cell where you entered the Effort (NOT IMPACT), then press the Select Range button again.
      6. In the “Series Y Values” section, press the button next to Select Range, then click on the cell where you entered the Impact, then press the Select Range button again.
      7. Click OK in the current window. Click OK in the next window.
      8. Repeat steps 1 through 7 for as many additional items as you have.
      9. Adjust the blue dividing lines and PICK text boxes as necessary to format properly.

      VN:F [1.9.22_1171]
      Rating: +1 (from 1 vote)

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Your Documents & Templates Belong Here


    Upload Now