How to Edit Pivot Chart in Excel (with Easy Steps)

If you are looking for how to edit a pivot chart in Excel, then you are at the right place. In our practical life, we often need to create pivot charts based on pivot tables and then need to edit them. A Pivot Chart in Excel is the visual representation of data. It gives us the big picture of our raw data. It allows us to analyze data using various types of graphs and layouts. In this article, we’ll study how to edit a pivot chart in Excel.


Download Practice Workbook


4 Steps to Edit Pivot Chart in Excel

Before editing a pivot chart, firstly, we need to make a pivot table. Secondly, we need to make the pivot chart. We have created a dataset named Sales of Amytech in 2022 which has headings as Branch Number, Month, and Sales in Columns B, C, and D respectively. The dataset is like this.

how to edit pivot chart in excel

Now, we’ll try to discuss the steps to edit the pivot chart.


Step-01: Preparing Chart from Pivot Table

Firstly, we have to create a Pivot Table.
To do this, firstly, select Insert > choose PivotTable > select From Table/Range.

how to edit pivot chart in excel, create the table

Secondly, select the dataset to fill up the bar of Table/Range of the following picture.

how to edit pivot chart in excel, create the table

A PivotTable window will appear like the picture below.
Thirdly, select Branch Number and Sales.
Fourthly, drag down Branch Number to the Rows bar and Sales to the Value bar.

how to edit pivot chart in excel, create the table

Eventually, we’ll find a pivot table like this where we have got the Sum of Sales in three different branches which is marked as Branch Name.

how to edit pivot chart in excel, create the table

Fifthly, we have to add a Pivot Chart.
To do this, firstly click anywhere on the pivot table> go to Insert > select PivotChart.

how to edit pivot chart in excel, create the chart

As a result, we’ll find a pivot chart like this.

how to edit pivot chart in excel, create the chart

Read More: How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart


Step-02: Adding Headings to Edit Pivot Chart in Excel

Suppose we want to add another heading in the pivot chart which is Month. To do this, firstly, we should select Month in the PivotTable Field window and then drag it into the Columns bar.

how to edit pivot chart in excel, add headings

Consequently, we’ll get the pivot table like this where the Sum of Sales is shown in different individual months in individual branches.

how to edit pivot chart in excel, create the chart

Simultaneously, the pivot chart will be like this where an extra variable, Month is added.

how to edit pivot chart in excel, create the chart

Read More: How to Use Pivot Chart in Excel (8 Suitable Examples)


Step-03: Showing Specific Results

Suppose, we don’t want to show all the information in the pivot chart. We want to show specific data in the chart. Let’s think that we need to show the Sales of different branches only in the month of January. We have three options in the pivot chart i.e. Sum of Sales, Branch Number, and Month. We can change or add any requirement in these three options marked below according to our requirements.

 show specific result

To show only Sales of different branches in January, we first need to click on the  Month option.
Consequently, the following bar will appear. We need to unclick other months except for January.
Lastly, click OK.

how to edit pivot chart in excel, show specific result

Eventually, we’ll find only the sales in January in the pivot chart.

 show specific result

Read More: Types of Pivot Charts in Excel (7 Most Popular)


Step-04: Addition of a Slicer to Edit Pivot Chart in Excel

A Slicer in Excel is a kind of filter we use to filter the data available in the pivot table as per the connections made between the slicer and the pivot table. Suppose, here we want to add a slicer of Branch Name and Month.
Firstly, go to Insert > click on Filters > select Slicer.

adding slicer

Eventually, the Insert Slicers window will appear.
Secondly, select Branch Name and Month. We can select any number of headings according to our resources available and requirements.
Thirdly, click OK.

adding slicer

As a result, we’ll get slicers like this.

adding slicer

From these slicers, we can select any options, and subsequently, the figure of both the pivot table and pivot chart will be changed. Here, if we select Branch 1 and January in slicers that means we want to show the sales in January in Branch 1 only. And consequently, the output becomes like this.

adding slicer

Read More: How to Filter a Pivot Chart in Excel (5 Suitable Ways)


Things to Remember

  • The pivot table and pivot chart are inter dependable. If we change one, another will be changed automatically. So we can edit the chart or table by changing both table and chart.
  • The shape of the pivot table and chart depends on the placement of headings in the PivotTable Fields. If we swap the rows and columns in the pivot table of this article the structure of the table and chart will change automatically.

Conclusion

We can create a pivot table, and pivot chart, and edit the table and chart if we study this article properly. This article shows the basic things associated with pivot tables and charts. Please feel free to visit our official Excel learning platform ExcelDemy if you have further queries.


Related Articles

 

 

Towhid

Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo