Learn how to create Nes Design Excel Column Chart which analyze your Current vs Previous Data set, which may be Yearly , Quarterly, Monthly or weekly basis.
This chart will quickly give you all of the insight like Total Current Sales, Previous and along with this show % changes.
File Link: https://drive.google.com/uc?export=do...
===CHAPTER===
0:00 Intro
0:38 Creating Pivot Table
1:31 Slicer Setting
2:23 Creating Helper Table (Core Step)
7:40 Chart Formatting
Other technique you need to learn:
• Highlight & Calculate Specific Columns in ...
• Display Both Percentage % & Value in Excel...