How To Create A Chart From A Pivot Table In Excel

This tutorial will show you how to create a chart from a pivot table in Excel with simple steps.

The pivot table is an essential and handy tool when we have a significant quantity of data. It helps us quickly and easily organize and summarize these amounts of data. However, a time might come when we want to visualize our data in a chart.

In doing so, you need not worry, as with just a few clicks, we can create a chart from a pivot table without a hassle, and that’s what you’ll be able to learn here. But before that, let’s take a quick look at a pivot table. Learn its meaning and what its uses are.

What is a Pivot Table?

As mentioned above, a pivot table is an essential Excel feature that helps users organize and summarize complex data quickly.

This feature allows users to group their data by columns, sort it by values, and calculate statistics. In addition, pivot tables are handy when you have a large quantity of data.

How to Create a Pivot Table

If you want to create a pivot table, you should have your data set. Once you have your data, you can start creating pivot tables. Here’s a tutorial on how to make one:

→ Click anywhere on your data, then the Insert tab.
In the Tables group, click PivotTable, then select “from table/range.”

Insert Pivot Table

→ After clicking “from table or range,” a PivotTable from table or range dialog box will appear.

Select “new worksheet” if you want to place your pivot table on a new worksheet. However, select “existing worksheet” if you want to place your pivot table on the same worksheet as your data, then select a cell where you want to place it and click OK.

PivotTable from Table or Range

Now that we already understand the pivot table and have even learned how to create one, let’s finally move on to the tutorial.

Create a Chart from a Pivot Table

The following is a step-by-step guide on how to create a chart from a pivot table.

  1. Click anywhere on your pivot table.

  2. Click the PivotTable Analyze tab.


    After clicking anywhere on your pivot table, click the PivotTable Analyze tab under the PivotTable Tools.

    PivotTable Analyze Tab

  3. Select PivotChart.


    After doing step two, select the PivotChart in the Tools group.

    Pivot Chart

  4. Edit Insert Chart dialog box.


    Lastly, click the OK button in the Insert Chart dialog box.

    Note: You can also choose different charts, depending on your preferred chart.

    Insert Chart Dialog Box

  5. Result.


    Create A Chart From A Pivot Table - Result

Note: You can filter and choose what to display in your chart by clicking the dropdown button for nuts and date (see image below).
Nuts Dropdown Button
Date Dropdown Button - How To Create A Chart From A Pivot Table In Excel

On the other note, you’ll notice a plus and paint sign beside the chart when you click it. They are called chart elements and chart styles. What are these?

  • Chart elements. In the chart elements, we can control what we desire to display in our chart.
Chart Elements

As shown in the picture, you can change (add or remove) the chart elements such as the titles, the data labels, the data table, the error bars, the gridlines, and more. It is done by checking or unchecking the checkbox provided.

  • Chart Styles. In the chart styles, we can control the chart style and color scheme for our charts by, of course, clicking on the style and color that we want for our chart.
Chart Styles

As shown in the picture, you can find different designs or styles by scrolling that scroll panel at the side. And you can also choose a different color for your chart by clicking the color tab.

Create a Pivot Chart in Excel

Step 1: Select a cell in your data set, then click the Insert tab.

In the charts group, click the PivotChart button, then select PivotChart.

Select Pivot Chart - How To Create A Chart From A Pivot Table In Excel

Step 2: After clicking PivotChart, a Create PivotTable dialog box will appear.

Select “new worksheet” if you want to place your pivot chart on a new worksheet. However, select “existing worksheet” if you want to place your pivot chart on the same worksheet as your data, then select a cell where you want to place it and click OK.

Create PivotChart - How To Create A Chart From A Pivot Table In Excel
Keyboard Shortcut: Click Alt + N + SZ + C keys to show the Create PivotChart dialog box.

Conclusion

In conclusion, creating a chart from a pivot table in Excel is easy and quick. Learning how to do it is also an easy thing to do. By following the simple steps in this article, there’s no doubt that you’ll learn it quickly.

I believe that we have accomplished this tutorial. I hope you’ve learned something from this. Do not forget to share this with your friends. If you have any questions or suggestions, please leave a comment below, and for more educational content, visit our website.

Thank you for reading!

Leave a Comment