Requirement:–
We need to showcase our management regarding the progress in Automation.So rather than giving them quantitative data we thought of sharing it in more presentable manner using Pivot charts.
Hope it help our fellow automation friends in creating easy and rapid reports.
Please feel free to share Your experience as comments, as we always believe sharing is caring.
Do follow us for more updates FB,LinkedIn,G+
Download dummy Excel
Solution:-
Step1:- Getting Data from ALM(Application life cycle management),
Note:- It can vary depending on the management tool which is used in the organization but still the approach would be same.
A)Testing -> Test Plan -> Select the Test Folder -> Live Analysis Tab -> Click on ‘Add Graph’

B)Select ‘Summary Graph’ -> Click Next

C) Select any value for X-axis field -> Click Finish

D)Graphical view would be generated -> Click on the bar graph tower

E)Drill down Results window opens

This is what we were waiting for, we can change what all the columns we need in our report.Further we would export the report in Excel format.
![]() |
Selecting columns in Drill down results view |
![]() |
Exporting excel from Drill down results |
Step2:-Creating Pivot Chart
A)We have our required data in Excel,we can edit to make any required changes like headers or any other modification.
B)Insert -> Pivot Chart
C)Select the Table/Range for Pivot Chart -> Click Ok
D)Select from “Pivot Chart” Fields, the columns that we need to displayed in Pivotchart report
Check the two variations of graph when we changed the data under Axis and Values.
![]() |
Pivot chart view-1 |
![]() |
Pivot Chart view-2 |
Step3 :- Playing with the design of the Pivot chart
One’s our chart is ready we can change the color or display design (Like pie chart) to make it look more impressive and easy to comprehend
Just select chart -> click on brush
We can also change the shape of graph, INsert -> Charts -> Select the chart option as suitable(Do select the chart below to check the live effect)