Site icon TestingDocs.com

How to create a Pie chart using Excel

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 data

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.

Below is the sample data of an automated test run for an application. Total tests for the application are: 84

Automated Tests Count
Passed 53
Failed 22
Skipped 9

Steps

Launch Excel application.

Add the data in the columns.

Choose >> Insert >> Insert Pie or Doughnut Chart.

 

Pie Chart

 

 

Exit mobile version