We use cookies essential for this site to function well. Please click to help
us improve its usefulness with additional cookies. Learn about our use of cookies in our Privacy Policy.

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.

I have used ggplot2 for the plot. I am having one issue in that, the col 8 is starting from the left end of the x axis and the col 9 should start from the right end of the x axis and the labeling is also a concern, like when col 8 starting at left end of the x axis the value is 0 and the line graph achieve the 100 at the end of the x axis. Conversely col 9 is starting from the right end of the x axis with 0 as the starting value and coming towards the left achieve 100 at the starting point of the col 8 starting point.