Dear Narasimha Rao Bhupalam,
I hope the attached file can give a better explanation on how to create a pivot chart.
Warm regards,
Kid.
On Wed, Oct 24, 2012 at 11:08 PM, bhupalam rao <n_bhupalam@yahoo.com> wrote:
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 <mr.nmkid@gmail.com> wrote:
From: Mr. Kid <mr.nmkid@gmail.com>
Subject: Re: ]] XL-mania [[ Needed help in 2-D Pie
To: XL-mania@yahoogroups.com
Date: Tuesday, October 23, 2012, 6:33 PMHi narasimha Rao Bhupalam,
Pivot chart can do this.
Regards,
Kid.On Mon, Oct 22, 2012 at 10:40 PM, bhupalam <n_bhupalam@yahoo.com> 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
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat jalan SitiVi, semoga bahagia di sisi-Nya... |
| Maaf moderasi lemooOooOott... momods siboek |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| Selamat jalan SitiVi, semoga bahagia di sisi-Nya... |
| Maaf moderasi lemooOooOott... momods siboek |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
.
__,_._,___
Nenhum comentário:
Postar um comentário