Re: $$Excel-Macros$$ Help on Graph

2010-10-26 Thread Shrinivas Shevde
Dear Remy Thanks for reply but it doesnt work Shrinivas On Mon, Oct 25, 2010 at 6:08 PM, RemyMaza remym...@gmail.com wrote: You have a white text cell of =na() for the month of May. You also need to format the cells into numbers. After those two tweaks, the min max worked for me. Cheers,

Re: $$Excel-Macros$$ Help on Graph

2010-10-26 Thread RemyMaza
That's interesting. I cleared the contents of the cell and the formulae began to work. What exactly do you mean: It doesn't work? Matt On Oct 26, 5:08 am, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Remy Thanks for reply but it doesnt work Shrinivas On Mon, Oct 25, 2010 at 6:08

Re: $$Excel-Macros$$ Help on Graph

2010-10-26 Thread Shrinivas Shevde
Dear Remy Can u attached a file? Shrinivas On Tue, Oct 26, 2010 at 7:09 PM, RemyMaza remym...@gmail.com wrote: That's interesting. I cleared the contents of the cell and the formulae began to work. What exactly do you mean: It doesn't work? Matt On Oct 26, 5:08 am, Shrinivas Shevde

Re: $$Excel-Macros$$ Help on Graph

2010-10-26 Thread Srinivasan Ethirajalu
have hidden column to calculate min max. refer attachment On Wed, Oct 27, 2010 at 9:12 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Remy Can u attached a file? Shrinivas On Tue, Oct 26, 2010 at 7:09 PM, RemyMaza remym...@gmail.com wrote: That's interesting. I cleared the

Re: $$Excel-Macros$$ Help on Graph

2010-10-25 Thread RemyMaza
You have a white text cell of =na() for the month of May. You also need to format the cells into numbers. After those two tweaks, the min max worked for me. Cheers, Matt On Oct 25, 12:37 am, Shrinivas Shevde shrinivas...@gmail.com wrote: Really talented answer . Now I have Another problem.

Re: $$Excel-Macros$$ Help on Graph

2010-10-24 Thread Shrinivas Shevde
Really talented answer . Now I have Another problem. For the same data I want to Find out Average,Min,Max I could manage for Average using Averageif but Min And Max I am not getting showing (NA) value look at the attached sheet. Can Any one help me to solve this Issue. Shrinivas On Fri, Oct 22,

$$Excel-Macros$$ Help on Graph

2010-10-20 Thread Shrinivas Shevde
Dear All, Can Any one help me on graph ? Thanks in advance. -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Help on Graph

2010-10-20 Thread Siva Kumar Vemula
Hai Srini, Please find attached modified. regards, siva On 10/20/10, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear All, Can Any one help me on graph ? Thanks in advance. -- Shrini -- -- Some important

Re: $$Excel-Macros$$ Help on Graph

2010-10-20 Thread Ajay Varshney
Solution is in the attachment. I have used Pivot table and used NA for values of blank. Ajay Varshney On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All, Can Any one help me on graph ? Thanks in advance. -- Shrini --

Re: $$Excel-Macros$$ Help on Graph

2010-10-20 Thread Shrinivas Shevde
Thanks Ajay and Vijaykumar,Shiv kumar Both Option I can not use (Pivot Table and 0 values) Is there any another option any setting Shrinivas On Wed, Oct 20, 2010 at 11:13 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Srinivas, Just keep zeros whereever there are no values. Regards,

$$Excel-Macros$$ Help on Graph

2010-02-08 Thread $...@mmy
Hi All, Could any one help me out with plotting the attached graph. Currently I get them manually adjusting the dots based on the axis. Is there a way where in i get the variables in the table and the Graph gets automatically updated? Regards Shyam --