I am trying to convert the example table below into a chart, but I am unsure what is the best way to go about doing this. I want two separate lines for # of Employees and Turnover %. I want the company names to be in the legend with different colored lines and I want the week number to be on the horizontal axis. Is there a way that this can be done? Thank you!
Company Week # # of Employees Turnover % ABC 25 50 25% DEF 25 60 30% GHI 25 70 35% JKL 25 80 40% ABC 30 55 20% DEF 30 65 25% GHI 30 75 30% JKL 30 80 35%
Bookmarks