If you wish to remove data from your pivot chart, use the filters provided by Excel. Excel will place your pivot chart here as opposed to creating an entirely new workbook. Existing worksheet : Select one of your already existing worksheets.You can switch between other worksheets in your workbook to stay more organized. New worksheet : Creates a new, blank worksheet for your pivot chart.Next, choose where you want your pivot chart to be placed. Here, simply click on the Choose Connection button and select a compatible data set for Excel to work with. You may also switch your selection to Use an external data source. If you wish to expand or reduce the selection, simply modify the numbers.

By default, Excel will select a range for you, however, this is completely customizable. The first “ Choose the data that you want to analyze ” part you’ll see in the dialog box prompts you to select the range of your pivot chart. Once you’ve found it, click on it once to open the Create PivotChart dialog box in a new window. You can locate this near the other chart types. Once you’re in the Insert tab, you should be able to see a button that says Pivot Chart. You’ll see a plethora of features come up, as this tab houses most of Excel’s pre-made charts, graphs, tables, and even illustrations. Use the Ribbon interface on top of the Excel window and switch to the Insert tab. Customize how you want your table to be created, and click OK.In the Tables group, click on Pivot Table.Click on any single cell inside your data set.If you don’t have a pivot table, create one by following these steps: We’ll be using one of these sets to demonstrate how pivot charts work. A pivot table allows you to extract data from a large, detailed data set. To be able to create a pivot chart, you need to first have a pivot table. If you don’t have one yet, simply create a blank workbook and get started on entering some data. You need to open the Excel workbook you want to work with.

If you require any help, don’t hesitate to reach out to us. However, the steps below were written for modern versions of Excel, such as Excel in Office 365, Excel 2019, and Excel 2016. This method works for both Windows and Mac versions of Microsoft Excel. In this article, we’ll walk you through the 10 steps of creating a Pivot Chart in Excel. Unlike regular charts, Pivot Charts are highly customizable and interactive, allowing you to stay on top of your data at all times with minimal maintenance required. Do you want to learn how to make a Pivot Chart in Excel? Pivot Charts in Excel are one of the easiest and best ways to visualize your data.

Excel 2016 pivot chart tutorial