Question:

a) Construct a line chart to examine the "Total Sales" growth (row 89 of the worksheet) across each month in 2012. Format the chart with the title "Quickstove Product Sales" and a legend to the right of the chart. Use the months in row 6 of the worksheet as the labels for the horizontal axis. Add a linear trendline to the chart.

b)Construct a line chart to compare the sales trends for the following products and kits: Firebox Deluxe Combo Kit, Firebox Master Combo Kit, Folding Firebox Campfire Stove, and Quickstove Fuel Disk. Format the chart with the title "Sales For Selected Products" and a legend to the right of the chart. Use the months in row 6 of the worksheet as the labels for the horizontal axis.

Please show me how to create these graphs...

Quickstove sells a number of different products. They also sell product bundles. The table on the "Product Sales" worksheet details the total sales revenue by month for each of the products and bundles that Quickstove sold in 2012. Create a line chart to examine trends in sales for certain products and bundles June 2012 Quickstove Product Sales March April May $570 $190 July August February $380 September October January $190 November December $950 $475 $8 $312 $20 $206 $12 $165 $47 $238 $12 $10 $54 $105 $88 $28 $20 $24 $24 $64 $30 $31 $24 $198 $75 $128 $25 $315 $219 $110 $278 $364 $ $74 $6 $48 $ $237 $110 $73 $8 $78 $122 $109 $235 $95 $37 $218 $B $62 $ $50 $68 $16 $125 $253 $499 $269 $324 $50 $450 $90 $993 $469 $15 $35 $ $155 $266 $486 $70 $294 $34 $416 $17 $293 $17 $25 $110 $34 $86 $20 $ $3,660 $435 $737 $3,552 $750 $686 $4,481 $750 $ $4.167 $2,089 $3,389 $900 $3,091 $750 $3,879 $1,170 $6,079 $1,549 $3,051 $1,320 $350 $494 $2,669 $702 $3,469 $1,300 $649 $ $550 $2,666 $88 $4,563 $1,391 $549 $412 $2,280 $632 $2,595 $528 $2,577 $4,935 $1,370 $250 $215 $2,448 $2,762 $694 $3,398 $100 $2,573 $140 $3,166 $766 $3,275 $788 $3,719 $100 $4,613 $3,080 $30 $14 $13 $14 $54 $33 $ $13 $8 $20 $34 $8 $32 $40 $30 $7 $27 $15 $126 $88 $15 $155 $80 $110 $80 $32 $35 $114 $20 $ $20 $20 $425 $25 Product 3 Month Fuel Supply with Stove Accessory Kit Adjustable Fire Grate Aluminum Matchbox Blue Bag Boil Plate Celestron UpClose G2 10:25 Roof Binocular Ceramic Knife Sharpener City Deals 9-Pack Shipping Cordura D-Ring Bag Cube Stove + 2 Fuel Disks Cube Stove +9 Fuel Disks Cup Charger Deluxe Combo Kit Distance Pedometer Emergency Cook Kit Extended Grill Plate Fire Starter Kit Firebox Accessory Kit Firebox Bundle Firebox Deluxe Combo Kit Firebox Master Combo Kit Firebox Stove w/ Fuel Firebox Upgrade Kit Folding Firebox Campfire Stove Folding Firebox Nano Folding Spork Fox 40 Whistle Gerber Bear Grylls Ultimate Survival Kit Gerber Sven Saw 21 GoalZero Solo LED Flashlight Granite Gear Shoulder Strap Pocket Grill Plate GSI Bugaboo Teflon Mess Kit Guyot Designs Bowl Set Heavy Duty Cordura D-Ring Bag Hexagon Backpacking Stove Hexagon Bundle - Save 40% Highgear Soloscope Humless Roadrunner Power Klean Kanteen Wide 40 oz Klean Kanteen Wide 64 oz Leatherman Freestyle Litech Coffee/Tea Kettle Living Social Voucher Shipping Master Combo Kit Nalgene Cantene 32 or Nalgene Cantene 96 Olicamp Pot Lifter Olicamo Space Saver Cup Olicamo XTS Pot Power Bank Portable Backup Charger with Flashlight Powerpot Quick Stove - Replacement Fuel Cells Quick Stove Can quickStove QuickStove 9-Pack Shipping Quick Steve Can QuickStove Can Shipping Quick Steve Fire Starter QuickStove Fuel Disk Red Cleaning Pad Red Scotch Brite Pad Replacement Fuel Cells Salt and pepper Shaker Set of 2 Fire Sticks SIAC Fuel Cell Solar Keychain Solo Storm Lighter Stainless Steel Cooking Pot Stainless Steel Cup Charger Stave In A Can Sun Thermo-Compass The Ugly Bag - Heavy Duty VCP Bag Tick Key Trangia Fuel Bottle -0.3L Trangia Fuel Bottle - 0.5L Trangla Fuel Bottle - 1.0L Trangia Spirit Burner UCO Micro Candle Lantern Upgrade Kit Varro Stove w/ Fuel Total Sales $106 $33 $246 $33 $35 $23 $44 $405 $37 $565 $23 $ $10 $13 $25 $12 $5 $ $13 $19 $ $66 $15 $28 $9 $30 $79 $129 $30 $ $127 $27 $180 $150 $225 $15 $150 $300 $150 $11 $142 $838 $385 $6,004 $184 $1,007 $351 $87 $592 $176 $1,765 $16 $530 $111 $457 $320 $1,546 $88 $14 $984 $161 $152 $698 $5 SS $610 $76 $77 $481 $2,346 $24 $144 $1,247 $132 $2,080 $24 $29 $264 $44 $104 $58 $ $288 $441 $1,370 $351 $398 $953 $916 $98 $6 $9 $1,819 $412 $847 $32 $13 $124 $20 $112 $68 $5 $95 $137 $179 $136 $245 $145 $ $884 $4 $4 $19 $78 8 $8 $19 $76 $496 $8 $19 $80 $450 $19 $58 $218 $40 $150 $135 $ $1,975 $40 $80 $ $353 $1,366 $719 $1,297 $51 $9 $10 $20 $38 $40 $12 $45 $9 $60 $6 $16 $17 $99 $19 $18 $64 $10 $ $6 $40 $18 $33 $49 $70 $130 $45 $43 $30 $58 $15 $195 $15 $20 $72 $14,387 $10,835 $12.324 $16.795 $13,565 $14.103 $17539 $17.518 $15.447 $9.936 $12.923 $19, 159 Quickstove sells a number of different products. They also sell product bundles. The table on the "Product Sales" worksheet details the total sales revenue by month for each of the products and bundles that Quickstove sold in 2012. Create a line chart to examine trends in sales for certain products and bundles June 2012 Quickstove Product Sales March April May $570 $190 July August February $380 September October January $190 November December $950 $475 $8 $312 $20 $206 $12 $165 $47 $238 $12 $10 $54 $105 $88 $28 $20 $24 $24 $64 $30 $31 $24 $198 $75 $128 $25 $315 $219 $110 $278 $364 $ $74 $6 $48 $ $237 $110 $73 $8 $78 $122 $109 $235 $95 $37 $218 $B $62 $ $50 $68 $16 $125 $253 $499 $269 $324 $50 $450 $90 $993 $469 $15 $35 $ $155 $266 $486 $70 $294 $34 $416 $17 $293 $17 $25 $110 $34 $86 $20 $ $3,660 $435 $737 $3,552 $750 $686 $4,481 $750 $ $4.167 $2,089 $3,389 $900 $3,091 $750 $3,879 $1,170 $6,079 $1,549 $3,051 $1,320 $350 $494 $2,669 $702 $3,469 $1,300 $649 $ $550 $2,666 $88 $4,563 $1,391 $549 $412 $2,280 $632 $2,595 $528 $2,577 $4,935 $1,370 $250 $215 $2,448 $2,762 $694 $3,398 $100 $2,573 $140 $3,166 $766 $3,275 $788 $3,719 $100 $4,613 $3,080 $30 $14 $13 $14 $54 $33 $ $13 $8 $20 $34 $8 $32 $40 $30 $7 $27 $15 $126 $88 $15 $155 $80 $110 $80 $32 $35 $114 $20 $ $20 $20 $425 $25 Product 3 Month Fuel Supply with Stove Accessory Kit Adjustable Fire Grate Aluminum Matchbox Blue Bag Boil Plate Celestron UpClose G2 10:25 Roof Binocular Ceramic Knife Sharpener City Deals 9-Pack Shipping Cordura D-Ring Bag Cube Stove + 2 Fuel Disks Cube Stove +9 Fuel Disks Cup Charger Deluxe Combo Kit Distance Pedometer Emergency Cook Kit Extended Grill Plate Fire Starter Kit Firebox Accessory Kit Firebox Bundle Firebox Deluxe Combo Kit Firebox Master Combo Kit Firebox Stove w/ Fuel Firebox Upgrade Kit Folding Firebox Campfire Stove Folding Firebox Nano Folding Spork Fox 40 Whistle Gerber Bear Grylls Ultimate Survival Kit Gerber Sven Saw 21 GoalZero Solo LED Flashlight Granite Gear Shoulder Strap Pocket Grill Plate GSI Bugaboo Teflon Mess Kit Guyot Designs Bowl Set Heavy Duty Cordura D-Ring Bag Hexagon Backpacking Stove Hexagon Bundle - Save 40% Highgear Soloscope Humless Roadrunner Power Klean Kanteen Wide 40 oz Klean Kanteen Wide 64 oz Leatherman Freestyle Litech Coffee/Tea Kettle Living Social Voucher Shipping Master Combo Kit Nalgene Cantene 32 or Nalgene Cantene 96 Olicamp Pot Lifter Olicamo Space Saver Cup Olicamo XTS Pot Power Bank Portable Backup Charger with Flashlight Powerpot Quick Stove - Replacement Fuel Cells Quick Stove Can quickStove QuickStove 9-Pack Shipping Quick Steve Can QuickStove Can Shipping Quick Steve Fire Starter QuickStove Fuel Disk Red Cleaning Pad Red Scotch Brite Pad Replacement Fuel Cells Salt and pepper Shaker Set of 2 Fire Sticks SIAC Fuel Cell Solar Keychain Solo Storm Lighter Stainless Steel Cooking Pot Stainless Steel Cup Charger Stave In A Can Sun Thermo-Compass The Ugly Bag - Heavy Duty VCP Bag Tick Key Trangia Fuel Bottle -0.3L Trangia Fuel Bottle - 0.5L Trangla Fuel Bottle - 1.0L Trangia Spirit Burner UCO Micro Candle Lantern Upgrade Kit Varro Stove w/ Fuel Total Sales $106 $33 $246 $33 $35 $23 $44 $405 $37 $565 $23 $ $10 $13 $25 $12 $5 $ $13 $19 $ $66 $15 $28 $9 $30 $79 $129 $30 $ $127 $27 $180 $150 $225 $15 $150 $300 $150 $11 $142 $838 $385 $6,004 $184 $1,007 $351 $87 $592 $176 $1,765 $16 $530 $111 $457 $320 $1,546 $88 $14 $984 $161 $152 $698 $5 SS $610 $76 $77 $481 $2,346 $24 $144 $1,247 $132 $2,080 $24 $29 $264 $44 $104 $58 $ $288 $441 $1,370 $351 $398 $953 $916 $98 $6 $9 $1,819 $412 $847 $32 $13 $124 $20 $112 $68 $5 $95 $137 $179 $136 $245 $145 $ $884 $4 $4 $19 $78 8 $8 $19 $76 $496 $8 $19 $80 $450 $19 $58 $218 $40 $150 $135 $ $1,975 $40 $80 $ $353 $1,366 $719 $1,297 $51 $9 $10 $20 $38 $40 $12 $45 $9 $60 $6 $16 $17 $99 $19 $18 $64 $10 $ $6 $40 $18 $33 $49 $70 $130 $45 $43 $30 $58 $15 $195 $15 $20 $72 $14,387 $10,835 $12.324 $16.795 $13,565 $14.103 $17539 $17.518 $15.447 $9.936 $12.923 $19, 159