Heat Map ..
Jul 9, 2009
Trying to find the Row(Window) and Column(Percentile) of the highest value in the grid. The value in Cell:AF7 finds the value in the grid(Heat map).
Once we calculate the Max value in the grid. We set the number of data points Above/Below in Cell:AI7 (This we enter in manually).
We then go into the Cells in the grid(Heat map), and then calculate the sum of the cells above and below the maximum number (which is returned in Cell AF7) dependant on the number of Data points Above/Below we are looking for. An example of this is done in Column D to M Rows 51 to 61. The sums are calculate of the cells above and below our maximum value in the grid.
We then want to return the maximum value of the sums of the data points above and below and then return the Percentile and Window Value.
As an example. Our max value on the heat map is 35.30026 and we want 2 Data points Above/Below. Then the maximum sum is 39.12358. Thus the percentile is 0.62 and the Window is 28.
View 11 Replies
Aug 31, 2006
Does any one have VBA code that draws a heat map or color map based on input data. I would like to vary colors & size of the boxes based on input variables. Something similar to this example would be neat -- [url]
View 9 Replies
View Related
Jan 5, 2007
I need to create many XY charts in a VBA macro. For each chart, I need to select a particular column for the X dimension, and a particular column for the Y dimension. When I use a named range to define the X and Y columns, my macro works fine for those instances when the X comes first. However, if my desired Y dimension comes first, I cannot find a way to correctly select these.
The context is such that my spreadsheet always has the same data fields in the same columns, but the numbers of rows vary. In addition, I need to dynamically select which rows to use, based on the values in the columns to be plotted. I’ve figured out how to do this within the macro, except for those instances when the Y column comes before the X. An example when this works:
Sheets("Raw").Select
Names.Add Name:="newRange", RefersTo:="=$K13" & ":" & "$K" & FirstBias _
& ",$M13" & ":" & "$M" & FirstBias, Visible:=True Range("K1").Activate
Charts.Add
ActiveChart.ChartType = xlXYScatterLines
ActiveChart.SetSourceData Source:=Sheets("Raw").Range("newRange"), PlotBy:=xlColumns
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Field10vsField12"
With ActiveChart
.HasTitle = True........................
View 3 Replies
View Related
Jun 23, 2014
I am trying to create a Heat Map for Risk in a spreadsheet that auto populates. Very simple dataset and I can convert my values to numeric if that makes the graph easier. Data Set is basically as follows:
Column 1 - Risk Description
Column 2 - Impact (score of 1-5)
Column 3 - Probability (score of 1 to 5)
Column 4 - Risk Indicator (Col 2 x Col 3 to give score out of 25.
Looking to create Heat map with upper right being my highest risk and lower left the improbables or low impact. I should mention that my VBA is as good as my Latin skills, i.e. Zero! so looking for a way of doing it through excel, either suggested or inbuilt charts.
View 3 Replies
View Related
Sep 10, 2013
I'm trying to create UK County heat map, however I can't seem to find example of one I could edit.
View 1 Replies
View Related