• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOW TO BUILD UP STOCKS HEAT MAP

d380013

d380013

New Member
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
 
is it possibale with Chart ? experts pls have a look


highly obliged


Thanks


Dhaval Shah

Ahmedabad,

M) 98240 35253
 
Hi d380013,


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


Thanks
 
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,
 
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 % ???
 
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,
 
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
 
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]
Code: 
-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,
 
You must log in or register to reply here.
Back
Top