Hi Ahmed, Those groups has 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 you still have challeng(es) in this regard. -- 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 4:12 PM, Ahmed Honest <ahmedhon...@gmail.com> wrote: > Dear Dilip, > > Can you explain the logic, of getting the Unit Price 25-30, > 30-35......................... as the source date holds no such units. > > > 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