Question-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.

Summary: This area chart shows the monthly sales trends of different product categories, with eyeliner and foundation consistently leading in total sales from 2004 to 2007.

Question 2: Using the Sales by Region.xlsx dataset, create a bubble chart with Number of Products on the x-axis, Percentage of market share on the y-axis, the size of the bubble using Sales, and each bubble’s color using Sales Region.

Summary: This bubble chart shows that the Northwest (NW) region has the highest market share (42%) among the sales regions, followed by the Midwest (MW) at 33%, with bubble sizes indicating total sales across different regions.