#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: The area plot reads and reprocesses a makeup data set, aggregates the data by month and product, then creates an area plot showing the price range of makeup products over time.
#2. 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.
Summary: The bubble chart depicts sales data by region, where the x-axis represents the number of products, the y-axis represents the percentage of market share, the size of each bubble corresponds to sales, and each bubble’s color indicates the sales region.