How to Make a Pivot Chart in Excel

It has happened to everyone. Working on an Excel table with tons of data and getting lost in it. Isn’t it the worst? Not knowing how to present some results properly is one of the worst things that could ever happen. What if I’d tell you that the solution can be easy enough and it’s called Pivot Chart?

What? Never heard of Pivot Charts in Excel? Oh well, that’s no problem at all! We’re about to show you everything you should know about how to make a Pivot Chart in Excel!

In this guide you’ll find:

  • What is a Pivot Chart?
  • Create a Pivot Chart in Excel
  • Conclusion

DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

What is a Pivot Chart?

The Pivot Chart is a visual representation of the Pivot Table. A Pivot Chart is a dynamic chart that allows you to interactively modify the graph’s presentation and information to your liking.

A great aspect of using Pivot Charts is the flexibility and the simplicity of the tool. Once the chart is created, you can easily change the information in the graph without taking the risk of making unwanted mistakes that could ruin the integrity of the chart itself.

As we’ve already said, there’s a strong connection between Pivot Charts and Pivot Tables. The Pivot Chart takes all information included in the graph from a pivot table. For this reason, before creating a Pivot Chart, it is very important to be able to create a Pivot Table in Excel. 

Chart, pie chartDescription automatically generated

Create a Pivot Chart in Excel

When we create a Pivot Chart in Excel, we obviously need to start from a collection of data. Let’s assume that we already have a table that includes all data and we want to turn it into a dynamic chart that graphically represents our business.

Let’s look for the Pivot Chart button in the top menu under the section Insert.

ApplicationDescription automatically generated with low confidence

If you can’t find the button, remember that you can type “pivot Chart” in the top search bar. The “action button” PivotChart will appear in the results and you’ll be able to click it from there.

ApplicationDescription automatically generated with medium confidence

Once you clicked the Pivot Chart button, a window appears. Similar to when you create a pivot table, you’re asked to select a data range and decide where you want to create the Pivot Chart. 

Make sure to select the right table or data range and pick the right spot for creating the chart. Then, click OK.

Graphical user interface, text, applicationDescription automatically generated

Now, it’s very important to understand that every Pivot Chart comes with a Pivot Table. So don’t be surprised when you see two elements appear on your screen.

Select all the desired PivotTable Fields and build your Pivot Table including all parameters that you want the chart to show. If you don’t know how to do it, you can find out more on our guide about How to Make a Pivot Table in Excel.

Graphical user interface, application, table, ExcelDescription automatically generated

Once your Pivot Table is ready, you’ll notice that the same data will be included in the Chart.

In fact, the Chart will always mirror its connected Pivot Table.

Chart, pie chartDescription automatically generated

At this point, if you right-click the Chart and hit Format Chart Area you’ll be able to customise your chart using different colours and fonts.

We recommend you to spend some time on this, as the presentation of results is crucial. You always want your chart to be catchy and clear.

Graphical user interface, applicationDescription automatically generated

Once you are done with all of the above, the Chart is ready to be shown to your colleagues, your boss or your mates. And remember: you’ll be able to change all columns and filters in the chart by simply selecting new Pivot Table Fields. It will be easy enough and won’t create the confusion of selecting data and creating new tables.

Your Pivot Chart gives you the great opportunity to display data in a simple and tidy way. Your data will be clear and your chart won’t be overloaded with information.

Conclusion

We’ve just shown you how to make a Pivot Chart in Excel. A Pivot Chart can really help you present results and report data. It also gives you a great opportunity to build a graphically pleasant chart that allows you to play around with all data and show all the main parameters.

Pivot Charts are always one of the best solutions to present results as they look very clear and simple and they are customisable on the spot.

Pivot Charts are a great feature included in Microsoft Excel. If you don’t own Microsoft Excel, you must know that it is part ofthe Microsoft Office Collection. To make things easy for you, we give you the opportunity to purchase your own Microsoft Office License, simply clicking here!

If you want to know more about Microsoft Office in general, we got you covered. In fact, you can find out more on our guide about How Much Does Microsoft Office 365 Cost? Deals, Price and Free Trial.

Do you find Microsoft Excel very interesting and you’d like to learn more about it? Well, you should know that we’ve published a few interesting guides about some cool Excel features.

One of those allows you to find duplicates in a list of data. That might sound like an easy job, however, the cool thing about it is that in our guide we explain how to remove duplicates but keep one of each. If you want to learn more, check out our guide about How to Find and Remove Duplicates in Microsoft Excel, now!

Also, another great function in Microsoft Excel is called Xlookup. The Xlookup gives you the opportunity to analyse different columns of data and create a new one that returns matching results. It might sound complicated, but it can be very useful and if you follow our guidelines it will be worth it. Read our guide to learn how to use Xlookup in Excel (with examples)!

Make sure to take advantage of all the greatest features of Microsoft Excel, it will really change your professional life!