Pivot Table headings that say column/ row instead of actual label
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
From https://www.auditexcel.co.za/blog/how...
Images on website
You’ve built your Pivot Table in MS Excel, but the column and row labels are not showing the name of the relevant field. How can you fill the empty labels with the headings in a Pivot Table?
As shown below, the default set up for a Pivot Table is to have the words ‘Column Labels’ and ‘Row Labels’ instead of the actual names as shown in the Pivot Table tool. However, you may want the actual names of the column or row to be shown.
fill the empty labels with the headings in a Pivot Table
This is an easy fix. You just need to change the report layout. As shown below, while clicked on the Pivot Table:
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Column Label and Row Label as names in the Pivot
00:14 Fixing the labels so that it shows what those rows and labels are (change report layout)
00:30 Impact of Outline form- actual labels are shown
00:37 Default compact form and what it looks like
00:49 Outline form and what it looks like
00:55 Tabular form and what it looks like (RECOMMENDED)
------------------------------------------------------------------------------------------------------------------------------------------------------
In the DESIGN ribbon
Click on REPORT LAYOUT
Choose ‘Show in Outline Form’ (or Tabular form)
fill the empty labels with the headings in a Pivot Table
As shown below, the actual name of the database column will appear in the Pivot Table.
fill the empty labels with the headings in a Pivot Table
You can learn more about Pivot Tables in our MS Excel Pivot Tables Online Course.
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.
