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
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.