1 Reply Latest reply on Nov 7, 2018 5:16 PM by Sonia Sawhney

    Industry Average Reference Line

    Sonia Sawhney

      Hello, I'd love some help creating a reference line that is an industry average. For example, for a specific customer I have their average 'employer rating' (blue line) over time and I want to add a reference line that shows their industries 'average employer rating' over time. I've gotten as far as the screenshot below (I can't post a packaged workbook as my workbook includes confidential data) but the reference line I have created shows this specific employer avg. employer rating and I want to be able to plot "biotechs average employer rating" if that makes sense? Basically I want a company to be able to understand how their rating compares to the industry rating. Thanks!

       

      industry average reference.png