HOW TO BUILD UP STOCKS HEAT MAP

[d380013]

Happy christmas to all valuable members,


I want to build up stocks heat map with 4 angel


here with share a photo copy of what i want & Raw data


https://docs.google.com/open?id=0B01xhb1Lk7tmdTFzV2xBRjN0SmM


Thanks


dahval Shah

 

[d380013]

is it possibale with Chart ? experts pls have a look


highly obliged


Thanks


Dhaval Shah

Ahmedabad,

M) 98240 35253

 

[Faseeh]

Hi d380013,


Welcome to the Forums!! Pleas wait for a couple of hours i will try to upload what i am working over.


Thanks

 

[Faseeh]

Hi d380113,


Please see this file, i will try to improve it:


http://dl.dropbox.com/u/60644346/heat%20map.xlsm


Need your feedback,


Regards,

 

[d380013]

Dear thanks a lot for u r feedback really excellent work & highly obliged


how to imporve in finalyy output in X & Y aixs instade of can we put 0 to 25 & 25 to 200 % ???

 

[d380013]

Dear Faseeh


really a gr88 help thanks a lot


Dhaval Shah

 

[Faseeh]

Hi D380013,


Sorry for late reply, i just reached my office when you posted the second last comment. You can put i manually on X-Axis or simply use a combination of INDEX() and MATCH() to bring numerical values from sheet2 to the final chart!!


Hope that helps,


Regards,

 

[d380013]

Dear Faseeh,


When i am try to change the data in Data Sheet heat map dosent work i am puting new data in sheet 01012013 ( pls check ) is it any hidden formulas ???


https://docs.google.com/open?id=0B01xhb1Lk7tmbW14SE9YTTIwOG8

 

[Faseeh]

Hi d380013,


Thank for feedback. Please note that you need to adjust the following ranges according to maximum and minimum in your data set, I just changed it for you so that you can understand:

[pre]

-60	A	-25%	R
-30	B	0%	S
0	C	25%	T
30	D	50%	U
60	E	75%	V
100%	W

[/pre]
..Please note that if you add extra categories to this work book you will need to adjust the combination of the two (AR, AS, AT....so on ) in the Sheet "RoughWork" in 11, 12 & 13th row.


Here is the reworked file:


http://dl.dropbox.com/u/60644346/d380013_Reworked.xlsm


Hope that works!


Regards,