Thermometer Graph (Dynamic)

[SravanP]

Dear All,

I have attached a excel sheet to depict what i plan to achieve. Planning to build the Thermometer graph based on the date selected by the user. Hence, it involves dynamic calculation of the data and require your support in building the formula.

Can this be achieved by using Array


http://www.2shared.com/document/EPyv0ign/ExcelQuery_Thermometer.html


Regards,

Sravan

 

[Hui]

SravanP

Try in:

I5: =+SUM(OFFSET(C5,1,1,MATCH($C$2,$B$6:$B$9,0)))

I6: =+SUM(OFFSET(D5,1,1,MATCH($C$2,$B$6:$B$9,0)))

 

[SravanP]

Thank you, Hui. It works.


Regards,

-Sravan

 

[dan_l]

?


I'm confused.