6 Replies Latest reply on Apr 20, 2018 8:36 AM by james.evans.10

    How to create a specialized bullet graph

    james.evans.10

      Alright so basically I am trying to recreate a gauge style graph I saw but with my own data using a bullet graph instead. In my workbook I have measures labeled "A" and "E" and the ratio between the two measures labeled "A/E". The optimal range for A/E is between 0.21 and 1.33 but the A/E ratios range from 0-186 so I would like to create a bullet graph that I can use dynamically to drop in any individual ID number and see where the A/E ratio falls (inside or outside the desired range). Essentially I want to be able to keep the range constant and be able to drop in any ID number and see where it falls into the range. Can anyone help?