Hi Gaurav,
I have explained the funda / logic in my previous emails in this chain email itself. Anyways, same is reproduced below for your convenience. Those groups have been created by using "Group and Show Detail" feature of Pivot Table. Just right click on the pivot table and you'll see this option. Get back in case of any queries. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Wed, Jul 14, 2010 at 12:27 PM, GAURAV JAIN <jaingaura...@gmail.com>wrote: > Hi Dilip, > > Can u explain how u did 25-30,30-35 in pivot table & chart? > > Thanks & Regards, > Gaurav Jain > > > On Tue, Jul 13, 2010 at 8:30 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Hey Ahmed.. the "Honest" man.!! :) >> >> You are most welcome to share the knowledge and experience(s) and >> offcourse for a friendship filled with learning - both the sides.. :) >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On Tue, Jul 13, 2010 at 3:59 PM, Ahmed Honest <ahmedhon...@gmail.com>wrote: >> >>> Hey Dilip, >>> >>> Greetings and Best wishes, >>> >>> I too gave a try to this query but winded up witha query in mind that >>> their was 0-27, 27-32 series so, to proceed further i was in confusion that >>> which series shall i follow with the difference of 27 or 5 and kept quite. >>> >>> But the way you answered is really *GREAT*. Hats of Buddy for your >>> logic and thinking. and wishes for one of my query which i posted, you >>> answered it! i forgot to reply back so i am here. >>> >>> I welcome you from my side for a honest Friendship. If you wish accept >>> the invitation by replying to this mail and i wish to share with you your >>> experience and knowledge. >>> >>> Waiting in anticipation for your reply. >>> >>> >>> Regards >>> Ahmed Bawazir. >>> >>> On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey >>> <dilipan...@gmail.com>wrote: >>> >>>> Hey mr. Soni.. >>>> >>>> Two Charts has been created as per your requirements >>>> >>>> 1) Normal chart >>>> 2) Pivot Chart >>>> >>>> Get back to me in case of any queries. >>>> >>>> -- >>>> Thanks & Regards, >>>> >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B.Com(Hons),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 62, India >>>> >>>> >>>> On Mon, Jul 12, 2010 at 1:13 PM, Rajender Soni <soni.rajen...@gmail.com >>>> > wrote: >>>> >>>>> Sir, aap hi kuch karo. >>>>> >>>>> Regards >>>>> Rajender Soni >>>>> >>>>> ---------- Forwarded message ---------- >>>>> From: Rajender Soni <soni.rajen...@gmail.com> >>>>> Date: Mon, Jul 12, 2010 at 12:45 PM >>>>> Subject: Urgent - MS Excel charts >>>>> To: excel-macros@googlegroups.com >>>>> >>>>> >>>>> Hi >>>>> >>>>> I have product category in column A, Product code in column B, and >>>>> their prices in Column C, now I want to make a chart showing the products >>>>> which comes under the price category of 0 to 27, 27-32 and accordingly, >>>>> pls >>>>> let me know how to show the same data in chart format, using different >>>>> colors for different product category. >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Rajender Soni | +91 750 322 55 50 >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Rajender Soni | +91 750 322 55 50 >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> >>> >>> -- >>> Ahmed Bawazir >>> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
