+ Reply to Thread
Results 1 to 3 of 3

Risk Heat Map help

  1. #1
    Registered User
    Join Date
    01-22-2015
    Location
    Bournemouth, England
    MS-Off Ver
    2013
    Posts
    2

    Risk Heat Map help

    All,

    Having trouble trying to plot a risk heat map and I am no expert on VBA or in fact excel generally. I need the workbook below to plot items on heat chart on 'sheet 1' from the data on sheet 'owssvr'. I also need this to be editable if further risks are added or if the probability / impact changes on my next import...is this possible?!

    Thanks in advance

    Attachment 372155
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Risk Heat Map help

    I never use these sorts of things, so I would have to rely on other's expertise. A quick internet search found this tutorial (http://chandoo.org/wp/2013/05/28/excel-risk-map/ ) that seems to be very similar to what you are trying to do here. I would suggest that you review Chandoo's'/Vijay's tutorial. Then explain in detail exactly what step or part of their suggested process that you get stuck on. That will help us focus specifically on what you are having trouble with rather than needing to recreate the entire heat map tutorial.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-22-2015
    Location
    Bournemouth, England
    MS-Off Ver
    2013
    Posts
    2

    Re: Risk Heat Map help

    Thanks Mr Shortly, I had seen this before. I was more hoping to manipulate my sheet as the instructions from the site you mentioned was only for a 5x5 grid. Mine is a 10x4 and I would know how to adapt the code accordingly.

+ 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. [SOLVED] Risk Register Heat Map
    By tasboxster in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-27-2017, 01:45 PM
  2. [SOLVED] Heat Map
    By TexasKersh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-23-2014, 09:28 AM
  3. [SOLVED] Creating Risk Heat Map without VBA?
    By TexasKersh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2014, 05:12 AM
  4. Heat map
    By rs232 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 01-05-2010, 10:05 AM
  5. Heat Map
    By sajeel in forum Excel General
    Replies: 11
    Last Post: 07-13-2009, 01:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1