heatmap

  1. N

    conditional formatting for 3-color scales with formulas

    Hi, I am trying to create a heat map using conditional formatting for 3-color scales with formulas. The heat map is supposed to work like this: Input a target date in cell D2 Input the date the Item was completed in cells A2-C2 If the completion date is more than 60 days prior to the...
  2. J

    World Map by country - custom color code

    Hello, I'm trying to find a way to show the world map with all countries. I want to color all countries based on criteria will be 4 colors. Example of country colors - cleared (blue) - removed (red) - review (yellow) - approved (green) What's the best way to do this? I'm not opposed to...
  3. I

    Heat mapping with excel and VBA

    Well, I am under no doubt this has been answered a million times, but can I figure it? Hell to the no, is the answer!! So I need your help. I have created a map of the of South of England, but post code region, which is the important bit, and the reason why I have created one rather than...
  4. B

    Trying to use countif function for a heatmap...

    Hi, I have been trying (and failing!) to use the countif function for a heatmap. In some cases there are two types of text data from a call log system that I need to extrapolate from the cells; I also need to do it between months of the year. For example; C...
  5. A

    Heatmap Excel Data onto Building Plan

    Is Excel able to create a Heatmap of data onto overlay of Building Plan ? I have specific Sales data for a Building with 100+ POS Terminals, I wanted to display a heat map onto the building plan to graphically display the Most Popular location to the Least. Have been googling, and can not...
  6. M

    Using a scatter graph to create a heatmap - how can I easily add multiple series

    Hello, I'm attempting to create a risk heat map in Excel (something like this, but with a more rigid scale). Currently I do this in PowerPoint and manually move the circles between boxes as and when the scores change, but I'm sure there must be an easier, more automated way to do it. My...
  7. I

    Dashboard creation

    HELPPPPPPPPPPPPP... I have just joined a new team at work and we dont have an MI team yet. no one in my team can do anything excel related other than opening up a sheet and thats about it. i really need some help creating a risk dashboard that shows the top 10 individuals in certain areas...
  8. E

    Conditional Formatting of a scatter graph

    Hi All, Thanks for checking this post, and thank you even more if you can help! I've had a search and found nothing the same as what i need to know, apologies if this has already been asked. I'm seriously stuck and in need of help, I need to plot a heatmap of data based on geographical...
  9. D

    Display a heatmap matrix showing % matches to other table values

    Hi all! First post (but long time lurker!). I've simplified the scenario and sample data I'm trying to solve to the following: I'm trying to create a heatmap matrix to show percentage of school classes each person was in with every other person. From the raw data (provided below), I want to...
  10. L

    VBA code to change object color based on value of another excel 2010

    Good morning, I am trying to create a heat map of the US that changes the shade of each state based on the values in another table range (B1:F45). There are 6 "tiers" of shade for each range of values: <colgroup><col><col></colgroup><tbody> 0 RGB(255,255,255) 1-140 RGB(235,241,222)...
  11. D

    How to Display Conditional Formatting of One Cell Based on Another

    Objective: to display conditional formatting of one cell based on another Conditions: If the cell is blank = white if the cell has a value less than variable X = green if the cell has a value equal to or greater than 1.24 of * X = yellow If the cell value is greater than 1.25*X = red. {X is...
  12. S

    Need formula for creating Heatmap log files

    I'm using excel 2007 and I'm trying to create heat map of system utilization. This is the first step (I will pivot data later to create map) - at the moment I'm just trying to understand the formula I need. I believe I'm coming at this from a very low tech approach that will require a pretty...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top