{"id":2641,"date":"2017-06-23T05:41:35","date_gmt":"2017-06-23T05:41:35","guid":{"rendered":"https:\/\/www.testingdocs.com\/questions\/?p=2641"},"modified":"2021-03-20T07:36:51","modified_gmt":"2021-03-20T07:36:51","slug":"how-to-create-a-pie-chart-using-excel","status":"publish","type":"post","link":"https:\/\/www.testingdocs.com\/questions\/how-to-create-a-pie-chart-using-excel\/","title":{"rendered":"How to create a Pie chart using Excel"},"content":{"rendered":"

Introduction<\/h3>\n

A pie chart is a visual representation of each category proposition to the whole in a circle. There are different variations of the chart in the Excel application. In this tutorial, we will learn to create a simple 2d Pie chart. Let’s create a sample pie chart for an automated test run.<\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Sample data<\/h3>\n

Let’s take sample data of an automated test run. When we run automated tests some tests pass, some fail and some tests might be skipped due to fail dependencies on other tests.<\/p>\n

Below is the sample data of an automated test run for an application. Total tests for the application are: 84<\/p>\n\n\n\n\n\n\n
Automated Tests<\/td>\nCount<\/td>\n<\/tr>\n
Passed<\/td>\n53<\/td>\n<\/tr>\n
Failed<\/td>\n22<\/td>\n<\/tr>\n
Skipped<\/td>\n9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Steps<\/h3>\n

Launch Excel application.<\/p>\n

Add the data in the columns.<\/p>\n

Choose >> Insert >> Insert Pie or Doughnut Chart.<\/p>\n

 <\/p>\n

\"Insert<\/p>\n

Pie Chart<\/h3>\n

\"Pie<\/p>\n

 <\/p>\n

 <\/p>\n\n

\n <\/div>\n\n","protected":false},"excerpt":{"rendered":"

Introduction A pie chart is a visual representation of each category proposition to the whole in a circle. There are different variations of the chart in the Excel application. In this tutorial, we will learn to create a simple 2d Pie chart. Let’s create a sample pie chart for an automated test run.   Sample […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2641","post","type-post","status-publish","format-standard","hentry","category-windows","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"_links":{"self":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/2641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/comments?post=2641"}],"version-history":[{"count":3,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/2641\/revisions"}],"predecessor-version":[{"id":19522,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/2641\/revisions\/19522"}],"wp:attachment":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/media?parent=2641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/categories?post=2641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/tags?post=2641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}