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.
Eye liner consistently achieved the highest monthly sales among all
cosmetic products during the period from December 2003 to January
2007.
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`
The Northwest (NW) region has the highest sales and project count,
while other regions vary significantly in sales and project
distribution.