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=download&id=1CbcPKGR_vhwzGVhJqfn_3HhlG0bPx47o

Other Useful Video To Creat Next Level Chart:
https://www.youtube.com/watch?v=Fv5dTnNjXG4
https://www.youtube.com/watch?v=9wAadpvLrY4
https://www.youtube.com/watch?v=apiFU3rKdK0
https://www.youtube.com/watch?v=B1yltiZlBfI
https://youtu.be/4RqHJ-8e0VU
---------------------------------
⏱️ 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! 💪

Видео MASTERING Stack Column Chart in Excel | SWITCH between PERCENTAGE % and ABSOLUTE VALUES with SLICER канала DataDash Pro