I have a data set in excel. There are total 9 columns:

col1 - member_id

col2 - A_timespent_in_hrs

col3 - B_timespent_in_hrs

col4 - total_timespent_in_hrs (col2 + col3)

col5 - A_pv (not to be considered in the problem)

col6 - B_pv (not to be considered in the problem)

col7 - total_pv (col5 + col6)(not to be considered in the problem)

col8 - A_timespent_in_hrs % wrt to total_timespent_in_hrs

col9 - B__timespent_in_hrs % wrt to total_timespent_in_hrs

I need to plot a graph in R (line graph) where i need to show the col8 ( A_timespent_in_hrs %) and col9 ( B_timespent_in_hrs %) on x axis and the count of col1 ( member_id) on the y axis.

Any help will be appreciated!

Thanks in advance,

Neel