Dear Kid, Thanks for your help.
I needed the steps how you have created the the 2-D pie. In a new work sheet, I am trying to create 2-D pie chart like you. I had selected pivot table and row labels. Please explain the me the stpes involved in getting count of status & 2-D pie. Waiting for warm reply, Regards Narasimha Rao Bhupalam Mobile No:+91 9886756395 --- On Tue, 10/23/12, Mr. Kid <[email protected]> wrote: From: Mr. Kid <[email protected]> Subject: Re: ]] XL-mania [[ Needed help in 2-D Pie To: [email protected] Date: Tuesday, October 23, 2012, 6:33 PM Hi narasimha Rao Bhupalam, Pivot chart can do this. Regards, Kid. On Mon, Oct 22, 2012 at 10:40 PM, bhupalam <[email protected]> wrote: Hi All, My data in xls is like this. S.No Test case status 1 reset test1 pass 2 reset test2 pass 3 reset test3 fail 4 soft rest test1 fail 5 soft rest test2 pass 6 basic test1 pass 7 basic test2 pass 8 basic test3 pass 9 randam test1 pass 10 randam test2 pass I needed help in creating 2-D pie diagram on column status, consisting of passed in green,failed in red & with total number of tests. Regards narasimha Rao Bhupalam
