Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

 

This type of interactive chart is great for impressive dashboards. Quickly learn how to create an Excel Pivot chart that's driven by pivot slicers.  

In this example I cover two topics: 

1. How to get Weekday name from a given date in Excel 
2. How to create a Pivot Chart controlled by a Slicer  In addition I show you how you can customize slicers in Excel to better match your report layout.

Related Topics:

• Excel Hidden Shortcut to Select Data Column including Blanks 
• Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before) 
• Excel 3D Formulas Explained (Includes a Bonus Excel Hack!) 
• Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)