EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Pivot Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Pivot Chart

By Jeevan A YJeevan A Y

Pivot Chart in Excel

Pivot Chart in Excel ( Table of Contents )

  • Pivot Chart in Excel
  • How to Create Pivot Chart in Excel?
  • Insert a Slicer to the Table

Pivot Chart in Excel

Most often, when the data is big and huge, it is difficult to draw conclusions and tell the stories behind the data. Pivot table could well be the tool that can help us in these crunch situations.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

A pivot table can cut, slice, summarize and give meaningful results from the data. Usually, in excel, after summarizing the data, we apply graphs or charts to present the data graphically to tell the story visually.

The pivot table does not require your special charting techniques rather; it can build its own chart using its own data. Pivot charts work directly with the pivot table and visualize the data in the most effective way.

In this article, I will explain to you the process of creating pivot charts in excel. This will be beneficial for you in your day to day workplace. Download the Excel workbook to practice along with me.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

How to Create Pivot Chart in Excel?

A pivot table is available in all versions of Excel.

You can download this Pivot Chart Excel Template here – Pivot Chart Excel Template

I have sales data of 4 regions across many months. I want to know the summary behind this data by using a pivot table in excel.

Pivot Chart Example 1-1

Step 1: Select the data.

Pivot Chart Example 1-2

Step 2: Go to Insert and apply a pivot table.

Pivot Chart Example 1-3

Step 3: Click OK.

Pivot Chart Example 1-4

Step 4: Drag and drop Region heading to the ROWS and Sum of Amt heading to the VALUES.

Pivot Chart Example 1-5

Now we have a summary report region-wise put together of all the months.

Pivot Chart Example 1-6

This report is only showing a numerical summary; if you need a graphical summary, you can insert Pivot Chart.

Step 5: Place the cursor inside the pivot table and go to Options. Under this, you will see the Pivot Chart option.

Pivot Chart Example 1-7

Step 6: Once you click on Pivot Chart, it will show you all the available charts for you. Select any one of them as per your wish.

Pivot Chart Example 1-8

Step 7: Your initial chart looks like this.

Pivot Chart Example 1-9

Step 8: Now add the Month heading to the COLUMNS field. It will break up the report into region-wise & month-wise.

Pivot Chart Example 1-10

Step 9: Now, look back at the chart. It has automatically updated its charting field. It is also showing the breakup of region-wise & month-wise visuals.

Pivot Chart Example 1-11

Step 10: Now, if you observe, there is one drop-down list available for MONTH & REGION in the chart itself. This is the controls for the chart.

Pivot Chart Example 1-12

Step 11: If you want to show the result only for the month of Jan, you can select the Jan month from the drop-down list.

Pivot Chart Example 1-13

Step 12: It will start to show the results only for the month of Jan. The important thing is not only in the chart section but also in the pivot region as well.

Pivot Chart Example 1-14

Step 13: Not only a pivot chart controls the pivot, but a pivot table to controls the pivot chart. Now the filter is applied in the pivot chart, but I can also release the filter in the pivot table as well.

Pivot Chart Example 1-15

Note: Both PIVOT TABLE and PIVOT CHARTS are interdependent. If any changes made to any file, it will affect both of them simultaneously. Both are an interdependent option in excel.

Insert a Slicer to the Table

All these while you worked with filters in excel. But we have visual filters in excel. Slicers are visual filters to filter out any particular category for us.

In our previous section, we selected the month from the drop-down list either on pivot chart or on pivot field, but using SLICERS, we can visually.

Step 1: Place a cursor inside the pivot table.

Pivot Chart Example 1-16

Step 2: Go to Option and select Insert Slicer.

Pivot Chart Example 1-17

Step 3: It will show you the options dialogue box. Select for which field you need a slicer.

Pivot Chart Example 1-18

Step 4: After selecting the option, you will see the actual slicer visual in your worksheet.

Pivot Chart Example 1-19

Step 5: Now, you can control both table and chart from the SLICERS itself. As per the selection you make in the slicer, both table and chart will show their results accordingly.

Pivot Chart Example 1-20

Advantages

  • Effective and dynamic chart.
  • Visualization and numbers are interdependent.
  • It shows drops, highs, lows, everything in a single graph.
  • Large data into a concise size.

Things to Remember about Excel Pivot Chart

  • If the data is increasing, you need to change the range of the pivot table every time data increases. So I will advise you to use Excel Tables for auto-updating of the pivot ranges.
  • Both PIVOT FIELD & PIVOT CHARTS are interdependent.
  • SLICERS can control both of them at a time
  • Since the chart is directly connected to the changing numbers, the range it becomes dynamic in nature.

Recommended Articles

This has been a guide to Excel Pivot Chart. Here we discuss creating Pivot Chart in Excel and practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Dynamic Chart in Excel
  2. Excel Stacked Column Chart
  3. Pivot Table Slicer
  4. Pivot Table Formula in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Pivot Chart Excel Template

EDUCBA

Download Pivot Chart Excel Template

EDUCBA

डाउनलोड Pivot Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more