Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav <prafulltjad...@gmail.com>wrote: > Dear All , > > Day before Yesterday I had gone for Interview for Data Analyst. They asked > me one question but i could not answer it . > > The Person who has taken my interview, asked me question on based on Meru > Cab where i was working earlier. > > Question was as below > > He asked me supposed Cabs are daily coming for Repair purpose in workshop > it can be 50,60,70,40,65,35...Nos then what will be daily average the > cabs graphs. > Answer was very easy for above question. > then he asked supposed suddenly in few days cabs reached at workshop with > 150,500,200..Nos. > > How will i show graphs or Summary with stable average count. > if i include the Highest numbers in series then Average suddenly goes > up..and charts look like jumping at highest point. > > for avoid this ..which type of formula i have to apply here which show > stable Average or Graphs. > > Regards, > Prafull Jadhav > 9920553518 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Chart (Prafull).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet