Hi, How your current file operates is more or less understandable from your previous file. Somehow what changes you need are still not clear. As Mr Don Guillett says could you attach a sample file with both current method and results that you need after change as sample?
Regards, Anand Kumar On Nov 19, 2:31 pm, renuka chari <jva.ch...@gmail.com> wrote: > 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
