MASTERING Stack Column Chart in Excel | SWITCH between PERCENTAGE % and ABSOLUTE VALUES with SLICER
In this video I will show you how to switch Stack column chart to % view with Slicer.
This Technique is useful if you want to show both % and Value in one single chart.
Download File Here: https://drive.google.com/uc?export=do...
Other Useful Video To Creat Next Level Chart:
• Display Both Percentage % & Value in Excel...
• Build Dynamic Pie Charts with Slicers for ...
• Level Up Your Excel Skills: Master Interac...
• Creating an Interactive Timeline Line Char...
• No more Cut Labels In Excel Bar Chart
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:12 Inserting Pivot Table
0:50 Duplicating Pivot Table
1:00 Show Monthly % values
1:24 Building Table for Slicer
2:19 Inserting Slicer
2:37 Formatting Slicer
3:17 Extraccting Selected slicer value
3:58 Master IF conditions
4:47 Custom Number Formatting
6: 23 Inserting Chart
Thanks for being a part of this channel and all your support! 💪