Assignment 5 - Section-1

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

The graph shows monthly sales(in$) trends for makeup products, with “EYE LINER” and “FOUNDATION” leading in revenue from 2003 to 2007.

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

The chart shows market share and product count by region, with bigger bubble size indicating sales, led by the NW region.