Creating a PivotTable, PivotChart and Trendline

profileRoy3394
Lab8-1AltarHoldings.xlsx

Sales Results

Altar Holdings Sales Results
Month Supplier Category Store Sales
1 Eastern Imports Housewares Omarell's $11,068
1 The Digital Shelf Digital Products O.G.'s Wholesale Club $26,949
1 StrongCore Sporting Goods Omarell's $10,820
1 Silkroad Stockist Accessories Ivy T's Emporium $9,207
2 Eastern Imports Housewares Omarell's $14,218
2 The Digital Shelf Digital Products O.G.'s Wholesale Club $27,640
3 Edison Electronic Digital Products Livingston $12,416
3 Eastern Imports Housewares Omarell's $9,649
3 The Digital Shelf Digital Products O.G.'s Wholesale Club $31,298
4 Edison Electronic Digital Products Livingston $14,282
4 StrongCore Sporting Goods Hendricks $18,758
4 Ivy T's Apparel Omarell's $37,936
4 Eastern Imports Housewares Omarell's $19,272
4 The Digital Shelf Digital Products O.G.'s Wholesale Club $32,011
4 Silkroad Stockist Accessories Ivy T's Emporium $12,967
5 Edison Electronic Digital Products Livingston $11,643
5 Ivy T's Apparel Omarell's $7,174
5 StrongCore Sporting Goods Hendricks $13,292
5 The Digital Shelf Digital Products O.G.'s Wholesale Club $24,087
6 Edison Electronic Digital Products Livingston $22,569
6 Homestyle Furnishings Furniture O.G.'s Wholesale Club $19,625
6 The Digital Shelf Digital Products O.G.'s Wholesale Club $23,918
6 Silkroad Stockist Accessories Ivy T's Emporium $9,919
7 Edison Electronic Digital Products Livingston $14,585
7 Wrentham Workwear Apparel Omarell's $20,498
7 Homestyle Furnishings Furniture O.G.'s Wholesale Club $22,119
7 StrongCore Sporting Goods Omarell's $16,175
7 Eastern Imports Housewares Omarell's $13,427
7 The Digital Shelf Digital Products O.G.'s Wholesale Club $21,058
8 Edison Electronic Digital Products Livingston $14,091
8 Wrentham Workwear Apparel Hendricks $14,618
8 Holling & Sons Apparel Livingston $9,550
8 Davis Family Apparel Apparel Ivy T's Emporium $17,151
8 Ivy T's Apparel Omarell's $11,051
8 Martin's Kitchen Suppliers Housewares Livingston $20,157
8 Silkroad Stockist Accessories Ivy T's Emporium $11,923
9 Edison Electronic Digital Products Livingston $12,218
9 Wrentham Workwear Apparel Omarell's $11,532
9 Holling & Sons Apparel Livingston $15,367
9 Ivy T's Apparel Omarell's $13,058
9 Martin's Kitchen Suppliers Housewares Livingston $12,184
9 The Digital Shelf Digital Products O.G.'s Wholesale Club $28,158
9 Silkroad Stockist Accessories Ivy T's Emporium $10,855
10 Edison Electronic Digital Products Livingston $21,721
10 Wrentham Workwear Apparel Omarell's $14,539
10 Holling & Sons Apparel Livingston $12,310
10 StrongCore Sporting Goods Hendricks $13,874
10 Martin's Kitchen Suppliers Housewares Livingston $13,824
10 The Digital Shelf Digital Products O.G.'s Wholesale Club $32,438
10 Silkroad Stockist Accessories Ivy T's Emporium $10,742
11 Edison Electronic Digital Products Livingston $26,429
11 Wrentham Workwear Apparel Hendricks $14,801
11 Eastern Imports Housewares Ivy T's Emporium $21,485
11 New Age Home Furniture Omarell's $28,523
11 Martin's Kitchen Suppliers Housewares Livingston $12,335
11 The Digital Shelf Digital Products O.G.'s Wholesale Club $17,333
11 New Age Home Furniture Ivy T's Emporium $18,443
12 Eastern Imports Digital Products Ivy T's Emporium $21,613
12 The Digital Shelf Digital Products O.G.'s Wholesale Club $15,639
12 New Age Home Furniture Ivy T's Emporium $27,714
12 Edison Electronic Digital Products Livingston $24,763