Overview

In this post, we will learn how to create line charts using an Excel application. As a tester this information is useful while reporting testing metrics, testing data or other important data etc. There are several tools and libraries to perform this task. However, we will look at manual steps to create a Line chart using excel

Steps for creating a Line chart

Launch Excel application.

Create an excel sheet with the reporting data as shown in the below picture.

Below is the sample data of TestingDocs.com ( this website ) data for a period of six months. Two metrics that are measured are the first time users of the website and returning users of the website.

 

 

Highlight the data to be included in the graph.

Click on the Insert tab of the ribbon.

Click on the Insert Line Chart icon to open the drop-down of available chart types.

 

 

Filter the data included in the Chart

Filter icon enables you to choose the elements that you want to appear in the chart. ( this step is for additional customization of the chart.)

Click on Apply button to apply the changes.

You can add Chart data like axis information, legend etc.

Double click on the chart title to modify it.

 

Now you will be able to visualize the data easily and makes it easy for others to understand the data and its trends.