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