Pinterest Pixel

Expand and Collapse Fields in Pivot Chart in Excel

Pivot Charts are really cool to use, as it gives you a great visual representation of your... read more

Download Excel Workbook
Bryan
Posted on

Overview

Expand and Collapse Fields in Pivot Chart in Excel | MyExcelOnline

Pivot Charts are really cool to use, as it gives you a great visual representation of your Pivot Table data. Did you know that you can actually Expand and Collapse Fields in your Pivot Chart? So that you can control the amount of detail to show in your Chart?

This is our source data.

Expand and Collapse Fields in Pivot Chart in Excel

This is our Pivot Table and Pivot Chart.

Expand and Collapse Fields in Pivot Chart in Excel

It is very simple to do so and we will show you how!

Expand and Collapse Fields in Pivot Chart in Excel | MyExcelOnline

Download excel workbookExpand-and-Collapse-fields-in-Pivot-Chart.xlsx

STEP 1: To expand your field, right click on a part of the chart, and go to Expand/Collapse > Expand Entire Field

Expand and Collapse Fields in Pivot Chart in Excel

With just that, your Pivot Chart has now expanded to the Sales Figures per Customer!

Expand and Collapse Fields in Pivot Chart in Excel

 

STEP 2:  Now let us collapse this back, right click on a part of the chart, and go to Expand/Collapse > Collapse Entire Field

Expand and Collapse Fields in Pivot Chart in Excel

 

Now your Pivot Chart has gone back to showing the Sales Figures by Region!

See also  Sorting a Pivot Table

Expand and Collapse Fields in Pivot Chart in Excel

 

How to Expand and Collapse Fields in Pivot Charts in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Expand and Collapse Fields in Pivot Chart in Excel | MyExcelOnline
Expand and Collapse Fields in Pivot Chart in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!