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.
From December 2003 to January 2007, eye liner continuously had the
greatest monthly sales of any cosmetic product.
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 distribution of sales and projects varies greatly throughout
regions, with the Northwest (NW) region having the greatest sales and
project count.