How to Group or Ungroup Data in a PivotTable

How to Group and Ungroup Pivot Chart Data Items in Excel?

Last Updated : 14 Jun, 2021

A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot tables are connected with each other. Pivot chart are much more flexible than normal chart because Pivot Chart is linked to a PivotTable. Filters, sorts, and data rearrangements applied to Pivot Table are reflected on the chart.

Steps to create Pivot chart :

Follow the below steps to create a Pivot chart:

Select the table to create the pivot chart.

Inside Insert tab, click Pivot chart.

A dialog box will appear, select the table and the cell where you want the table and chart.

Both Pivot chart and Table will be created, but no field is selected.

Select the fields, you want in the chart.

Chart will be formed.

To Group data in the Chart:

Follow the below steps to group data in the Chart:

Select the rows or columns from the table, you want to group.

Right-click and press group.

The data will be grouped and the chart will show those rows together along with the Group name.

To Ungroup data in the Chart :

Follow the below steps to ungroup data in the chart:

Select the group name.
Right-click and press Ungroup.

The data items in both the table and chart will be ungrouped.

How to Group or Ungroup Data in a PivotTable

I

ishikalohia4

Improve

Article Tags :

Similar Reads

How to Group or Ungroup Data in a PivotTable

Pivot Table Grouping is a feature that enables us to organize data into specific categories or ranges. It allows you to group data based on various factors, such as dates, numbers, or custom-defined intervals, making it easier to analyze and draw insights from the data. We will explore Pivot table g

How to Create Grouped Line Chart Using ggplot and plotly in R

Creating grouped line charts in R allows you to visualize multiple trends or series in the same plot. By using the combination of ggplot2 plotting and plotly for interactivity, you can create rich, dynamic visualizations that let you explore your data in depth. In this article, we will explore how t

How to Create Pivot Chart from Pivot Table in Excel using Java?

A Pivot Chart is used to analyze data of a table with very little effort (and no formulas) and it gives you the big picture of your raw data. It allows you to analyze data using various types of graphs and layouts. It is considered to be the best chart during a business presentation that involves hu

How to Create a Goal Line on a Chart in Excel?

Excel is a powerful data visualization and management tool that can be used to store, analyze, and create reports on large data. Data can be visualized or compared using different kinds of plots in Excel such as line charts, bar charts, etc. A goal line is also called a target line. It helps show ac

How to Update, Change and Manage the Data in a Chart in Excel?

Charts in Microsoft Excel enable you to display data in a way that has the most possible impact on your audience. Apart from displaying, it helps the audience to understand the data well and helps them to read the data correctly. Charts can be of many types like Pie charts, Bar charts, Scatter chart

How To Create a Tornado Chart In Excel?

Tornado charts are a special type of Bar Charts. They are used for comparing different types of data using horizontal side-by-side bar graphs. They are arranged in decreasing order with the longest graph placed on top. This makes it look like a 2-D tornado and hence the name. Creating a Tornado Char

How to Create a Thermometer Chart in Excel?

The Thermometer chart in Excel can be used to depict specific data based on the actual value and the target value. It can be used in a wide range of scenarios such as representing the past performance of horses in horse racing or the global temperature and it's variation throughout decades etc. In t

How To Represent Excel Data as Pie Chart in ReactJS?

In today's data-driven world, visualizing information is crucial for understanding trends and making informed decisions. Pie charts are a powerful tool for displaying the proportions of a whole, making them ideal for presenting Excel data in a clear and intuitive manner within a ReactJS application.

How to Create a Pie Chart in Excel - Step by Step Guide

Pie charts are an excellent way to visualize proportions and illustrate how different components contribute to a whole. Whether you're analyzing market share, budget allocation, or survey results, pie charts make complex data easily understandable at a glance. This guide will walk you through how to

How to Create a Chart from Multiple Sheets in Excel

Creating a chart from multiple sheets in Excel is a powerful way to consolidate data and visualize it in a meaningful way. Whether you're working with different datasets on separate sheets or need to compare data across multiple tabs, knowing how to create a chart from multiple sheets in Excel can s