BANL 6310-04_Assignment 5: Area and Bubble Plots

Using the MakeupDB.xlsx dataset, create an area plot with Months on the x-axis, Dollars on 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.

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.

The NW region leads in both the percentage of sales and the number of projects, while the MW region has the highest sales volume