Pivot chart are the visual representation of the Pivot table. Pivot table and charts both are connected or interrelated to each other. We use Chart as an extension to the Pivot Table. Any changes made in the Pivot table will be reflected in the Chart. Chart are More useful than the ordinary chart that Excel provides. This tutorial will explain you how you can create Chart in Excel, how you can filter your Pivot Charts and change your Pivot table type. We have taken two dimensional Pivot table in our Example
Insert Pivot chart in Excel | एक्सेल में पिवट चार्ट डालें
Following are the steps to Insert Chart in Excel:
Step 1: Click anywhere in the Pivot Table.
Step 2: On the Analyze tab, Tools Group, Select Pivot Chart. [Insert Chart dialog box appears]
Step 3: Click Ok
You will see that your Pivot Table will be graphically represented in the Chart format.
NOTE: Any changes made in the Chart or Pivot Table are reflected immediately.
Filter Pivot Chart in Excel | एक्सेल में फ़िल्टर पिवट चार्ट
Following are the steps to Filter Pivot Chart in Excel
Step 1: Insert a Chart in Excel [as explained above]
Step 2: We use the standard filter. In our example we have Divison and Rating as two standard to apply filter. We have filtered our Chart by selecting AD from the divison.
Step 3: Click ok
Step 4: Remove the Divison Filter that we had applied. We have Age in the Report Filter Category, so we can directly filter using Age Category to filter Chart. In our example we filtered our Chart for the age 19-28.
Step 5: Click ok
Change Pivot Chart Type | पिवोट चार्ट प्रकार बदलें
You can change your Pivot Chart type any number of time you want. Steps to change Chart in Excel
Step 1: Select the Chart
Step 2: In the Design tab > Type > Select Change Chart Type.
Step 3: Change Chart Type dialog box appears. Select from the different options available. We select Line Chart
Step 4: Click ok
Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.