Anomandaris

05-18-2009, 03:14 AM

hi guys,

need help again, this one appears a tad more complicated

What I'm trying to do is create something like a heatmap but not using the surface charts in excel, rather with text boxes. I dont know if this is the best way....It will be an 8 by 8 grid, with each box in the grid having 3 vertical cells- showing different statistical values calculated from another sheet.

I need the Current, average and z-score values to show up in each grid box in that order. then the box should be colored according to the value - negative values in different shades of blue, lowest being darkest (but not too dark as i'd like to read the number), positive values are red with largest values being darker shades of red lower values close to 0 having a whitish shade of red.

The coloring should depend on z-score value....actually i'll have option buttons setup on the page so the coloring can be determined by which option i choose (current, average or zscore), but for now lets just get it for the zscore.

here's the sheet, the data is on DV-IV Spread in the upper table, that has to be displayed in the heatmap sheet.....i have outlined what the grid would look like.

thanks

need help again, this one appears a tad more complicated

What I'm trying to do is create something like a heatmap but not using the surface charts in excel, rather with text boxes. I dont know if this is the best way....It will be an 8 by 8 grid, with each box in the grid having 3 vertical cells- showing different statistical values calculated from another sheet.

I need the Current, average and z-score values to show up in each grid box in that order. then the box should be colored according to the value - negative values in different shades of blue, lowest being darkest (but not too dark as i'd like to read the number), positive values are red with largest values being darker shades of red lower values close to 0 having a whitish shade of red.

The coloring should depend on z-score value....actually i'll have option buttons setup on the page so the coloring can be determined by which option i choose (current, average or zscore), but for now lets just get it for the zscore.

here's the sheet, the data is on DV-IV Spread in the upper table, that has to be displayed in the heatmap sheet.....i have outlined what the grid would look like.

thanks