top of page
Kyle Pew

How to Create Multiple PivotCharts from a Single Excel List


Are you looking to get more insights from your data using PivotCharts in Excel? In this guide, I’ll show you how to create multiple PivotCharts from a single list formatted as a table. This method allows you to visualize different aspects of your data without duplicating your dataset or making it more complex.


Step 1: Prepare Your Data as a Table

First, make sure your data is formatted as an Excel table. Using tables provides flexibility when creating PivotTables and PivotCharts because they automatically update as you add or remove data.


Step 2: Create Your First PivotChart

  • Select any cell within your table.

  • Navigate to the "Insert" tab and choose "PivotChart".

  • Make sure to use the option: USE AN EXTERNAL DATA SOURCE and select your table.

  • Configure your chart to summarize the table data.


Step 3: Create Additional PivotCharts

Here’s the trick to create multiple PivotCharts based on the same list:

  • Repeat STEP 2 to create additional PivotCharts to summarize different aspects of your data source.


Why Use This Method?

This approach is efficient and keeps your Excel workbook manageable. You don’t have to worry about creating separate datasets for each chart. Instead, you can create various views and insights from the same list, making your data analysis more streamlined.



EXAMPLE FILE DOWNLOAD:


567 views0 comments

Recent Posts

See All

Comments


bottom of page