Re: $$Excel-Macros$$ Need help on Graph

2013-04-11 Thread Prafull Jadhav
Thanks a lot for the same. On Thu, Apr 11, 2013 at 7:31 PM, P.VIJAYKUMAR wrote: > Dear Praful, > > There is plenty of difference between Data Validation and a drop down box > from the developer tab. > The list box in the data validation or data validation in general is used > for validating an

Re: $$Excel-Macros$$ Need help on Graph

2013-04-11 Thread P.VIJAYKUMAR
Dear Praful, There is plenty of difference between Data Validation and a drop down box from the developer tab. The list box in the data validation or data validation in general is used for validating an entry which adheres to specified condition or not.For example when a cell or range of cells a

Re: $$Excel-Macros$$ Need help on Graph

2013-04-11 Thread Deepak Rawat
Thanx!! to all of you it has solved my query completely. Regards, Deepak On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav wrote: > Dear Anil, > > Ok..thanks . > > Can you clear one things here ..is there any different between validation > and drop down box is taken from developer menu > > Regar

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread prafull jadhav
Dear Anil, Ok..thanks . Can you clear one things here ..is there any different between validation and drop down box is taken from developer menu Regards, Prafull. On Wed, Apr 3, 2013 at 10:48 AM, अनिल नारायण गवली wrote: > Dear Praful, > > Yes it is right. but even me didn't used any type of mac

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread अनिल नारायण गवली
Dear Praful, Yes it is right. but even me didn't used any type of macro here . the dropdown box is taken from developer menu. Warm Regards, Gawli Anil On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav wrote: > Dear Anil, > > I have created the same with help of validation and index formula by >

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread अनिल नारायण गवली
Dear Deepak, Pl see the attached sheet. Is it OK. Warm Regards, Gawli Anil On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi > > Kindly find attached , > i need a graph which change as i select the desired cell. > suppose if i want to see sales then when i wil select "Sale" cell the > g

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread Deepak Rawat
Thanx Ashish!! Regards, Deepak On Tue, Apr 2, 2013 at 7:24 PM, ashish koul wrote: > Try the attachment . double click on cell f3-f5 > > Regards > Ashish > > > On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > >> Hi >> >> Kindly find attached , >> i need a graph which change as i select the

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread ashish koul
Try the attachment . double click on cell f3-f5 Regards Ashish On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi > > Kindly find attached , > i need a graph which change as i select the desired cell. > suppose if i want to see sales then when i wil select "Sale" cell the > graph should s