Hi
I have two results I want to graph in one graph and I think the best way to show this could be one result displaying as a column graph and the other as a line graph. I am open to any other ideas to present these results in a different graph set up.
The results I am graphing is a star rating system, basically a 1 to 5 star result(first data set) is given depending on performance. The star result assigned is determined by what star %(second data set) is achieved.
For example a 1 star is achieved by receiving a star % below -50%, a 2 star is achieved by receiving a star % of -21% to -49%, a three star is achieved by receiving a star % of -20% to 20%, a 4 star is 21% to 39% and 5 star is above 40%
See attachment for the numbers I am looking to graph.
Thank Data to graph.xlsx
Bookmarks