1. Using the MakeupDB.xlsx dataset, create an area plot with Months on the x-axis, Dollars an the y-axis, and Product as the category. Note: you will have to summarize the data by month as a sum by month and product.

Area plot shows the sales of various makeup products from December 2004 to January 2007, the eye liner product achieving the highest sales.

  1. Using the Sales by Region.xlsx dataset, create a bubble chart with Number of Projects on the x-axis, Percentage of Sales on the y-axis, the size of the bubble using Sales, and each bubble’s color using Sales Region

Bubble chart shows product sales and market share by region sales. Larger bubbles indicating higher sales in a region.