Excel-Sales Dashbord- Sample
Sales Entry Data
Month
January
February
March
April
May
Product A Sales Product B Sales Total Sales-
Daynamic Convert Auto Update Sheet
Month
Product A Sales Product B Sales Total Sales
January-
February-
March-
April-
May-
Pivot Table
Row Labels
January
February
March
April
May
Grand Total
Sum of Product A Sales Sum of Product B Sales Sum of Total Sales-
Sum of Product A SalesSum of Product B Sales Sum of Total Sales-
Values
2500
Sum of Product A Sales
2000
Sum of Product B Sales
1500
Sum of Total Sales
-
January
Month
February
March
April
May
Sales Charts
SUM OF PRODUCT A SALES
January
February
March
April
May
14%
22%
22%
18%
24%
-
-
-
3500
-
-
-
1700
2400
1500
-
2200
-
2000
1500
1800
0
Sum of Product A Sales
Sum of Product B Sales
Sum of Total Sales