Questions tagged [heatmap]
8 questions
2
votes
2 answers
How can I create a heat map based on data from Google Analytics?
How would one go about creating a heat map (say, of the US) based on location data from Google Analytics? I'd like to somehow create such a map with the visitor data from several websites that use Google Analytics. I'm not really looking for a…
Travis Northcutt
- 921
1
vote
1 answer
Client Side Mouse Tracking Software
In 2 weeks we have a field test for our developed web application (company internal) and about 15 end users are invited to test our web application. For this field test we want to track their mouse clicks (location what was clicked).
Some…
Pali
- 222
0
votes
2 answers
Excel heatmap with 2 color rules - possible? Using trunc?
I have two tables showing the amount of Compound A and Compound B in the same samples. For example:
Compound A
Sample 1
Sample 2
Condition x
0.5
0.01
Condition y
0.05
0
Compound B
Sample 1
Sample 2
Condition…
Laura
- 103
0
votes
1 answer
How to make my PivotTable into a heatmap, persistently?
We can easily make an Excel table into a heatmap by applying a conditional formatting rule on the rectangle of relevant data cells. And - this can also be done for a PivotTable.
However, whenever you update the PivotTable - the conditional…
einpoklum
- 10,666
0
votes
1 answer
How do I generate a heatmap of the world with by-state data?
I have some dataset with pairs of the name of a state (not US state!) and a value (either categorical or on a scale). I would like to create a heatmap of the world, with the states marked on it, according to this data, on a Linux system.
Can I do…
einpoklum
- 10,666
0
votes
1 answer
Enter text on top of formatted cells in a heatmap created in excel without losing the color in the cells
I have created a heatmap in excel with correlation data. Now I want to indicate the p value significance. How do I enter * or ** without changing the color of the cell?
AB3
- 1
0
votes
0 answers
Create heat map excluding 0's and highlighting double counted values in heat map fashion
I was wondering if it is possible to create a heat map on excel, where values of 0 are excluded from the ranking, and the cells which contain the same values are highlighted in a heat map fashion?
In this case I have cells with 0 which I don't…
user156
- 133
- 4
0
votes
1 answer
Is it possible to 'superimpose/show' non-heatmap related data over an Excel range heatmap?
Is it possible to 'superimpose/show' data from a similarly shaped matrix over a range heatmap, instead of simply showing/hiding the underlying heatmap data?
The question could also be rephrased differently: Is it possible to generate a heatmap on…
