![]() |
dynamic chart- curve drops to zero ( Line)
Hi all i using following formula and description for the dynamic chart.
Please do the needful In B1 = Project start date , C1= Mar-10 In B2= Project duration , C2= 30 ( which may vary) In B3= Project Cost , C3= 10000000 In C6=+IF(ROW()-ROW(C$6)+1<=C$2,DATE(YEAR(C$1),MONTH(C$1)+ROW()-ROW(C$6),DAY(C$1)),"") Till C50 In D5=IF(OR(B6="",B6=0),"",B6/$C$2) till d50 In e5=IF(OR(D6="",D6=0),"",IF(D6<=33.33%,(($I$1*D6^2) *100),IF(D6<=66.67%,($I$2*D6+$I$3),IF(D6=66.67%,( $I$4+$I$5*D6+$I$6*D6^2)*100,"")))), till E50 In f5= IF(OR(B6="",B6=0),"",E6*$C$3), till F50 The problem i am facing is when i select the data for the chart ( C6:C50and F5: F50) depending upon the value in C2 the curve will show but after that curve drops to 0 , I don't want curve to drop 0 depend upon the value in C2 |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com