Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles PIVOT TABLE How to Create a Pivot Chart in Excel

How to Create a Pivot Chart in Excel

We can create a Pivot Chart that summarizes and displays our data for better comprehension. With Pivot charts, we can see comparisons, patterns, and trends in a simple outlay. We can create Pivot Charts from scratch or from a pivot table. The steps below will walk through the process of creating a pivot chart from scratch.

Figure 1- Example of a Pivot Chart in Excel

Creating a Simple Pivot Chart

Our pivot chart is always associated with a Pivot table report, hence, we will see a Pivot table report alongside the chart we created in our Excel worksheet.

  • We will enter our data in an array of rows and columns

Figure 2 – Preparing your Data

  • We will select any cell in our source data
  • In the Insert tab, we will click the Pivot Chart option

Figure 3- Clicking on Pivot Chart

Figure 4 – Create Pivot Chart Dialog box

  • We will click OK
  • We will select the Pivot Chart Fields and drag them to the position that we want

Figure 5 – Pivot Chart Fields

Figure 6 – Condensed Pivot Chart

  • Lastly, we can add a title to our chart as shown in figure 7
    • We will select the chart, then the layout table, then chart title
    • We will click on the chart and enter our title, “Sales Report”

Figure 7 – A Simple Pivot Chart

Explanation

We use Pivot charts to achieve a visual representation of our data or a pivot table in Excel. They are the best types of graphs because it’s easy to compare portions of data against other portions without altering our raw data.

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc