Go Back

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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar