PIVOT TABLE is a well known feature of GOOGLE SHEETS which everybody of us might have heard of. But many
times we don’t know how to effectively use the PIVOT TABLE.
PIVOT TABLE is a dynamic table which we can create in GOOGLE SHEETS. We called it dynamic as we can transform it within seconds. The original data remains the same.
CHARTS are the graphic representation of any data .
Analysis of data is the process of deriving the inferences by finding out the trends,totals, subtotals other operations etc. about different parameters.
PIVOT CHARTS ARE SIMPLY THE CHARTS MADE FOR THE PIVOT TABLES.
There is no direct option for PIVOT CHARTS in GOOGLE SHEETS. So we’ll learn to create pivot tables and how we can create visualizations there.
PIVOT CHARTS ARE THE CHARTS MADE FOR THE PIVOT TABLES. THEY ARE USED AS THEY PROVIDE US WITH THE DYNAMISM OF THE PIVOT TABLES.
Let us take an example for creating the pivot chart.
We’ll take the sales data on different days of a month and create pivot table first.
FIND OUT THE DAY WISE SALES OF THE TABLE USING PIVOT TABLES.
The very first step of creating a pivot chart is to create a pivot table for the given data.
Follow the steps to create the pivot table for the data.
Our PIVOT TABLE is ready after adding the rows and values.
Have a look at the picture below.
They Days shows the total sales in three week.
Now our pivot table is ready. So, it is time now to create a pivot chart.
Let us try to change the pivot charts.
The changes in the pivot charts can be simply done with the help of pivot table which is the data for the pivot chart.
– If we need to make changes in the data or function, edit the pivot table.
– If we want to make changes in the chart, chart titles, chart type etc. , edit the Chart options.
LET US CHANGE THE FUNCTION FROM SUM TO AVERAGE.
You must have noticed that although we changed the function from SUM to AVERAGE, but the chart titles and axis titles are not changed this time.
So we need to change them manually.
IT IS RECOMMENDED THAT YOU FINISH THE DATA EDITING FOR THE CHART AND EDIT THE CHART AND AXIS TITLES AT THE END.
The following picture shows the error change of titles.
As our titles didn’t change, let us change them manually.
Now , our pivot chart is finally ready.
We have changed the titles, Background color, opted for the 3D chart.
The final pivot chart is shown in the picture below .
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE