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 wrote: > Dear Remy > Can u attached a file? > Shrinivas > > On Tue, Oct 26, 2010 at 7:09 PM, RemyMaza wrote: > >> That's interesting. I cleared the contents of the cell and the >> form

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 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 wrote: > > Dea

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 wrote: > Dear Remy > Thanks for reply but it doesnt work > Shrinivas > > > > > > On Mon, Oct 25, 2010 at 6:08 PM, RemyMaz

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 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, > Matt > > O

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 wrote: > Really talented answer . > Now I have Another problem. > For the same data

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, 20

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

2010-10-22 Thread Srinivasan Ethirajalu
Best answer is =na( ) @anandydr: Very talented answer. GOOD LUCK * * On Fri, Oct 22, 2010 at 12:02 PM, anandydr wrote: > If we put =na( ) in the empty cell against May month the graph would > become straight, otherwise the average of april and june month may be > inserted there. > > On Oct 21,

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

2010-10-22 Thread anandydr
If we put =na( ) in the empty cell against May month the graph would become straight, otherwise the average of april and june month may be inserted there. On Oct 21, 6:03 pm, Danilo wrote: > Instead of a blank cell, insert the average between the previous and > the subsequent period. > DV > > On

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

2010-10-21 Thread Danilo
Instead of a blank cell, insert the average between the previous and the subsequent period. DV On Oct 21, 7:25 am, Shrinivas Shevde wrote: > 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 > > > > O

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 wrote: > Dear Srinivas, > > Just keep zeros whereever there are no values. > > > Regards, > Vijaykumar > > O

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

2010-10-20 Thread P.VIJAYKUMAR
Dear Srinivas, Just keep zeros whereever there are no values. Regards, Vijaykumar On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > > ---

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 wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > > --

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 wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > -- > Some important links for exc

$$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 Link

$$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 -- --