PRODUCT SALES

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.

Task Description

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.

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.

Data