Analyzed Fashion Group sales data in Excel
We have been given Sales data for Fashion Group store primarily by two supply chains: Next Look
& Fashions Direct
and required to present an overall analysis of Sales.
- We can create Map charts even for pivot tables , we just have to make a temporary table with pivot data by pasting it as values.
- Created Dynamic labels for Pie Chart
- Created sparkline trends using
GETPIVOTDATA
- Created single legends for whole dashboard manually(& not within each chart)