+ Reply to Thread
Results 1 to 1 of 1

Automatically plotting a grid depending on 2 different values.

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Automatically plotting a grid depending on 2 different values.

    Hi Guys,


    I am in need of your expert excel knowledge. I'm trying to find out an automatic method to plot data into the attached table.


    I have a massive list of data which has two fields, probability and impact. I want it to automatically to take only data above a certain value in both fields and then sort the data and put it into the relevant boxes.


    I guess I would have to assign each box certain values?


    Kind Regards,


    David
    Attached Images Attached Images

+ 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. Plotting Horizontal and Vertical Grid
    By seanyeap in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-12-2013, 09:42 PM
  2. Replies: 2
    Last Post: 12-15-2011, 04:14 AM
  3. Excel 2007 : Plotting id numbers on a grid
    By lou6755 in forum Excel General
    Replies: 1
    Last Post: 05-26-2010, 05:16 PM
  4. Plotting launch and land points (connected) in a grid
    By danagosto in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 09-23-2009, 09:15 AM
  5. Plotting locations on a grid?
    By ge0rge in forum Excel General
    Replies: 1
    Last Post: 11-10-2007, 08:25 AM

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