Moonfrog Interview Questions | Inflow Values

Write an automated script in excel VBA or in R (assume input in data.frame) to generate a stacked area chart Inflow vs. Date across different Sources in such a fashion that the maximum total inflow source is closest to the X (Date) axis and the least inflow source the farthest.

Assume the date, source and inflow values to be dynamic.