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.

This area plot displays monthly dollar sales across various product categories. The x-axis represents the months, while the y-axis indicates total sales in dollars. Each color corresponds to a distinct product.

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.

This bubble chart illustrates the relationship between the number of products and market share percentage across different sales regions. The x-axis represents the number of products, the y-axis indicates market share percentage, bubble sizes reflect sales volume, and colors distinguish between the sales regions.