hi Sam Mathai Chacko, Don Guillett.
thanks for ur responce Actually this Excel Project Will work like this: here Ohlc Sheet Having data it is automatically coming from yahoo site if we need to select symbol, next cell for company, and enter starting date and ending date then click on get data button then data will coming automatically here max & min values are depending on close column chart sheet having block size if we need to enter bolck size and click on drawchart then graph will display reversal is fixed constant Presently chart ranges are coming depending on the Fixed block size but I need like this, if Max & Min valus are Max is 6000 & min is 290 then when ever clicking on draw chart Button the scale should be display 6000-2900 range diff is 100 & 2900-1400 range diff is 50 & 1400-600 Range diff is 20 like this. i think my problem is clear if not plz feel free to give a responce thanks in advance Renukachari -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
